string = any()
От | Andy Colson |
---|---|
Тема | string = any() |
Дата | |
Msg-id | 4F0C5371.2090702@squeakycode.net обсуждение исходный текст |
Ответы |
Re: string = any()
Re: string = any() |
Список | 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
В списке pgsql-general по дате отправления: