Re: string = any()

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andy Colson <andy(at)squeakycode(dot)net>
Cc: David Johnston <polobo(at)yahoo(dot)com>, "'PostgreSQL'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: string = any()
Date: 2012-01-10 16:11:55
Message-ID: 24259.1326211915@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andy Colson <andy(at)squeakycode(dot)net> writes:
> This still does not work, even in psql:
> select 'bob' = any( '{''joe'', ''bob'' }'::varchar[] )

You've got the array quoting rules wrong here (should be double quote
marks, not single quotes). You didn't show us your PHP code but I
surmise that's got the same mistake. Read the array I/O representation
spec carefully:
http://www.postgresql.org/docs/9.1/static/arrays.html#ARRAYS-IO

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2012-01-10 16:18:27 Re: string = any()
Previous Message Ron Somaraju 2012-01-10 15:56:51 Re: How do you change the size of the WAL files?