有关于项目中将orl改为pgsql所遇到的数据库语法函数,以下均为自己所遇到的百度之后记录,便于日后总结
decode:https://www.cnblogs.com/rxhuiu/p/9120130.html
case when then:https://www.cnblogs.com/qlqwjy/p/7476533.html
concat():https://www.cnblogs.com/aiyr/p/6830593.html
|| :https://blog.csdn.net/u012768459/article/details/80239437
Cast( 字段名 as 转换的类型 ) :https://blog.csdn.net/qidasheng2012/article/details/84862266
oralce nvl( ) :https://www.cnblogs.com/yhoralce/p/6872121.html
COALESCE( ) 函数:https://blog.csdn.net/weixin_40417658/article/details/82633227
trunc( ) :https://blog.csdn.net/whandgdh/article/details/79663584
date_trunc( ) :https://blog.csdn.net/liguangxianbin/article/details/80166574
< ! [ CDATA[ ] ] > :https://www.cnblogs.com/ferby/p/9799164.html
substr( ) :https://www.jb51.net/article/52635.htm
exists( bool) :https://www.cnblogs.com/xuanhai/p/5810918.html
connect by prior:https://blog.csdn.net/wang_yunj/article/details/51040029/
with as :https://www.cnblogs.com/Niko12230/p/5945133.html
max( ) :https://www.w3school.com.cn/sql/sql_func_max.asp
sysdate:https://blog.csdn.net/gdkyxy2013/article/details/79693660
localtimestamp:https://vimsky.com/examples/usage/localtimestamp-function-in-mysql.html
某方法在规定时间没有返回,超时机制:https://www.cnblogs.com/wzy-525/p/12059460.html
rownum& lt; = { n:__rownum}
https://blog.csdn.net/qq_31156277/article/details/90447953
推荐一个网址:产看pgsql常用的函数:
nextVal( ) :https://www.cnblogs.com/personblog/p/11042105.html
lpad( ) :http://blog.sina.com.cn/s/blog_62defbef0101qjt5.html
有种rownum& ltde 写法,相当于分页limit的写法