| From: | Andy Colson <andy(at)squeakycode(dot)net> |
|---|---|
| To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | string = any() |
| Date: | 2012-01-10 15:04:17 |
| Message-ID: | 4F0C5371.2090702@squeakycode.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all.
I am writing PHP where it prepares a statement like:
$sql = 'select * from aTable where id = any($1)';
then in php I create a string:
$args = "{1,2,3}";
And run it:
$q = pg_query_params($db, $sql, $args);
This is not actual code, just a sample. And it works great for
integers. I cannot get it to work with strings.
Just running this in psql does not work either:
select 'bob' = any( '{''joe'', ''bob'' }' )
But this does:
select 'bob' = any( array['joe', 'bob'] )
But I can't seem to prepare and execute:
$sql = "select 'bob' = any( $1 )";
$args = "array['joe', 'bob']";
$q = pg_query_params($db, $sql, $args);
Running on 9.0.4 on Slackware 64.
Any hits would be appreciated.
-Andy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Filip Rembiałkowski | 2012-01-10 15:11:28 | Re: string = any() |
| Previous Message | Alban Hertroys | 2012-01-10 14:52:53 | Re: Update takes longer than expected |