How to select rows for which column has empty array ? - Mailing list pgsql-general

From Arup Rakshit
Subject How to select rows for which column has empty array ?
Date
Msg-id 1402065016.38538.YahooMailNeo@web193903.mail.sg3.yahoo.com
Whole thread Raw
Responses Re: How to select rows for which column has empty array ?
Re: How to select rows for which column has empty array ?
List 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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Postgresql service stopped automatically after restart
Next
From: Tom Lane
Date:
Subject: Re: interpret bytea output as text / double encode()