[postmodern-devel] Passing a list to a prepared query

[Sebastian Tennant]

Quoth Marijn Haverbeke <marijnh at gmail.com>:
> I think that Postgres doesn't allow the right-hand side of IN to be an
> $-parameter. Try something like
> this:
>
>  (defprepared addresses-by-ids
>      "SELECT address FROM users WHERE id = ANY($1)" :column)
>
> I think you'll still have to convert your list to a vector for
> cl-postgres to be able to put it in a parameter.

Many thanks.

Seb
-- 
Emacs' AlsaPlayer - Music Without Jolts
Lightweight, full-featured and mindful of your idyllic happiness.
http://home.gna.org/eap