Try select 'a' = any( $${a,x}$$ ) ;
or select 'a' = any( array['a','x'] ) ; On Sat, Aug 8, 2009 at 3:08 PM, Jasen Betts <ja...@xnet.co.nz> wrote: > jasen=# select 'a' = any( $${'a','x'}$$ ) ; > ?column? > ---------- > f > (1 row) > > I expect it to be true instead. what am I doing wrong? > > > PostgreSQL 8.3.7 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Debian > 4.3.2-1.1) 4.3.2 > > > jasen. > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >