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

2010-05-16 Thread Sebastian Tennant
Quoth Marijn Haverbeke : > 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 vecto

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

2010-05-15 Thread 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 th