How to select rows for which column has empty array ?
| От | Arup Rakshit |
|---|---|
| Тема | How to select rows for which column has empty array ? |
| Дата | |
| Msg-id | 1402065016.38538.YahooMailNeo@web193903.mail.sg3.yahoo.com обсуждение исходный текст |
| Ответы |
Re: How to select rows for which column has empty array ?
Re: How to select rows for which column has empty array ? |
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: