15 May
2010
15 May
'10
6:44 a.m.
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