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 _______________________________________________ postmodern-devel mailing list postmodern-devel@common-lisp.net http://common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel
