postgresql 补齐空值、自定义查询字段并赋值操作

select id,name,'/index/' url from table_name

stqyghmj = cast(nullif(" + stqyghmj + ", null)AS int)

ldclqk = '" + ldclqk + "'

INSERT INTO message(date_create) VALUES (LOCALTIMESTAMP);

// 获取当前时间
Timestamp currentTime= new Timestamp(System.currentTimeMillis());
# 以下字段sql不全，仅仅是引入变量时所需，currentTime必须添加单引号''
newColumnValue.append(",'").append(currentTime).append("'")

string_agg(ldphyy,';') as ldphyy

case when sum(sttkbyzx)>0 then 1 else 0 end as sttkbyzx

select * from news_info limit 10 offset 1