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

[Marijn Haverbeke]

Hey Sebastian,

>  (defprepared addresses-by-ids
>   "SELECT address FROM users WHERE id IN $1" :column)
>
> Is this possible?  I've tried a few different approaches but keep getting
> errors.

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.

Best,
Marijn