[DB-SIG] Parameter substitution and "IN" operator

Alex Willmer alex at moreati.org.uk
Tue Mar 18 00:35:03 CET 2008


On Tue, 2008-03-18 at 00:14 +0100, Gerhard Häring wrote:
> This is not the way SQL parameter binding works. SQL parameter binding
> only works with scalars (*). If tuples seem to work, then that's just
> a side-effect of the implementation of your particular DB-API module.

>>From here, it seems like native SQL parameter binding for tuples is a
good thing. Do relational databases not implement it merely because no
one has written the code yet, or is it missing from the SQL standard/a
bad idea in principle?

Regards, Alex



More information about the DB-SIG mailing list