Re: 'a' = any( $${'a','x'} )

From: Vyacheslav Kalinin <vka(at)mgcp(dot)com>
To: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 'a' = any( $${'a','x'} )
Date: 2009-08-08 11:43:41
Message-ID: 9b1af80e0908080443m4f9e2cdcjb866de77e5e2b5bc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2009-08-08 11:45:08 Re: 'a' = any( $${'a','x'} )
Previous Message Jasen Betts 2009-08-08 11:08:34 'a' = any( $${'a','x'} )