insert into test values(1, ARRAY['lxm','lxm2']);
insert into test values(2, ARRAY['lxm','lxm3']);
insert into test values(2, '{lxm,lxm3}');
查询name_list字段值中包含lxm的记录
imos=# select * from test where name_list @> '{lxm}';
id | name_list
----+------------
1 | {lxm,lxm2}
2 | {lxm,lxm3}
2 | {lxm,lxm3}
(3 rows)
数组添加元素(合并)
imos=# select * from test;
id | name
----+------------------------
2 | {wangwu,zhaoliu}
1 | {zhangsan,lisi,wangwu}
(2 rows)
imos=# select name||'{wangba}' from test where id=2;
?column?
-------------------------
{wangwu,zhaoliu,wangba}