Try
select 'a' = any( $${a,x}$$ ) ;
or
select 'a' = any( array['a','x'] ) ;
On Sat, Aug 8, 2009 at 3:08 PM, Jasen Betts <jasen(at)xnet(dot)co(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>