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
Arup Rakshit