eg:
c1
1
2
3
select string_agg(c1,',') from t1 group by c1
result :1,2,3
select GREATEST(33,4,3)
33
select LEAST(33,4,3)
3
select regexp_split_to_table(coalesce('/home/postgres/pg_basebackup.sh',''),E'\/') ;
home
postgres
pg_basebackup.sh
split_part(str,',',1)
selectsplit_part('A3332-22222222','-',1); - > A3332
selectsplit_part('A3332-22222222','-',2); - > 22222222
如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!
赞2
添加新评论0 条评论