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

Quoth Marijn Haverbeke <marijnh@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