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

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.

On Sat, Aug 8, 2009 at 12:08 PM, Jasen Betts<jasen@xnet.co.nz> wrote:
> select 'a' = any( $${'a','x'}$$ ) ;

postgres=# select 'a' = any( $${"a","x"}$$ ) ;
 ?column?
----------
 t
(1 row)


--
greg
http://mit.edu/~gsstark/resume.pdf

Try
 
select 'a' = any( $${a,x}$$ ) ;

or

select 'a' = any( array['a','x'] ) ;