Filip RembiaĆkowski wrote:
> fi...@filip=# prepare sth(int[]) as select * from ids where id = ANY($1);
> PREPARE
>
> fi...@filip=# execute sth('{1,2,3}');
> id | t
> +---
> 1 | eenie
> 2 | menie
> 3 | moe
> (3 rows)
Thanks!
> 2009/8/6 Ivan Voras mailto:ivo...@freebsd.org>>
>
>
fi...@filip=# prepare sth(int[]) as select * from ids where id = ANY($1);
PREPARE
fi...@filip=# execute sth('{1,2,3}');
id | t
+---
1 | eenie
2 | menie
3 | moe
(3 rows)
2009/8/6 Ivan Voras
> Is it possible to prepare a query with the IN clause in a meaningful
> way? I could p
Is it possible to prepare a query with the IN clause in a meaningful
way? I could probably do it with a hard-coded number of arguments, like
"SELECT x FROM t WHERE y IN ($1, $2, $3)" but that kind of misses the
point of using IN for my needs.
In any case, it would probably be a good idea to add a