![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库:postgresql
zy123698745
这个作者很懒,什么都没留下…
展开
-
postgresql知识点(一):部门递归
WITH RECURSIVE T (TEMPID,TEMPNAME,TEMPPID,TEMPPATH,DEPTH) AS (SELECTD1.TEMPID,D1.TEMPNAME,D1.TEMPPID,ARRAY [D1.SORTBY] AS TEMPPATH,1 AS DEPTHFROM(SELECT ‘0’ TEMPID, ‘TEST1’ TEMPNAME,’’ ...原创 2019-06-10 09:02:19 · 480 阅读 · 0 评论 -
postgresql知识点:查看表的字段名、字段描述等
select A.relname as 表名, B.attname AS 字段名, B.attnum as 字段排序, format_type (B.atttypid,B.atttypmod ) AS 数据类型及长度, B.attnotnull AS 非空, col_description ( B.attrelid, B.attnum ) AS 字段描述from pg_class...原创 2019-09-21 13:49:50 · 2575 阅读 · 0 评论 -
postgresql知识点:常用函数整理
求绝对值:abs(param)向上取整:ceil(param)向下取整:floor(param)取最小值:least(param1, param2, param3, ...)取余数:mod(divisor, dividend)四舍五入:round(param)统计数量:count(num)取平均值:avg(num)取最大值:max(num)取最小值:min(num)求和:sum...原创 2019-09-21 17:11:56 · 2441 阅读 · 0 评论 -
postgresql实例:生成指定范围内的随机数
生成指定范围“800~900”的10条随机数据:SELECT num FROM generate_series ( 800, 900 ) AS t ( num ) ORDER BY random ( ) LIMIT 10查询结果如下图所示:原创 2019-10-10 09:24:09 · 3964 阅读 · 0 评论