I have a below table :
yelloday_development=# select id,workplace_ids,team_ids from reporting_groups
;
id | workplace_ids | team_ids
----+---------------+----------
2 | {} | {}
3 | {} | {}
1 | {} | {}
4 | {1} | {1}
5 | {2} | {2,3,4}
(5 rows)yelloday_development=# select id from reporting_groups where 2 = ANY (team_ids) yelloday_development-# ; id ---- 5 (1 row) How would I select rows which has empty array for the field "team_ids" ? Regards, Arup Rakshit
