![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
PostgreSql
笔记_blog
黄桃罐头,伪猿
展开
-
postgreSql 查询语法总结
使用json 格式的查询记录:PostgreSQL JSONB 使用入门SELECT * from planning_orderSELECT(po.level_of_workings :: json ->> 'group') :: TEXT as xx, * FROM platform.planning_order po WHERE (po.level_of_workings :: json -> 'group') :: TEXT = 'GEO' -- a原创 2021-08-04 19:04:47 · 290 阅读 · 0 评论 -
Postgresql 函数
postgresql函数-- 查询随机数SELECT ceil(random()*(10000-1)+1) as num;SELECT floor(random()*(10000-1)+1) as num;SELECT trunc(random()*(10000-1)+1) as num;UPDATE ecc_masc_mds_temp SET create_time = null;SELECT CURRENT_TIMESTAMP -- 查询当前时间将数据从一个表拷贝到另一个表,而且原创 2021-06-23 18:17:55 · 137 阅读 · 0 评论