| 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: | Whole Thread | Raw Message | 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
>
| 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'} ) |