maybe try to use ARRAY constructor instead? http://www.postgresql.org/docs/9.0/static/sql-expressions.html#SQL-SYNTAX-ARRAY-CONSTRUCTORS 2012/1/10 Andy Colson <andy@xxxxxxxxxxxxxxx>: > 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 > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
