–查询序列号

select ROW_NUMBER() OVER(ORDER BY score DESC) from cust_basic_info

–查询序列号

select  ROW_NUMBER() OVER() sn , t1.* from _user t1;

 

–日期间隔计算

date_part(‘day’, (now() -stocktime)) <=3

 

–类型转换

select CAST (1234 AS text)

 

–日期变更

select timestamp ‘20131219’ + interval ‘3 month’

select now() + interval ‘3 month’

–手动增加 check约束和外键约束

alter table message add CONSTRAINT check_message_active CHECK (msg_type in(0,1))

alter table message add CONSTRAINT foreign_key_message_dialog_id foreign key(dialog_id) REFERENCES dialog(id)

—替换

update goods_pic set goodspicurl = overlay(goodspicurl placing ‘110’ from 18 for 2) 

–创建用户

createuser -drSP round_server