[DB-SIG] Multiple Statements

Gerhard Häring haering_postgresql@gmx.de
Tue, 28 May 2002 21:36:47 +0200

>From my interpretation of the DB-API specfication, it's not possible to
put multiple SELECT statements into one execute() call. That's what
.executemany() with .nextset() is for, right? Do I really have to
support this in a DB-API compliant module, though?

What about multiple non-SELECT SQL statements seperated by ; in an
execute() call (read: INSERT, UPDATE, PRAGMA).  Would this be valid?
Again I personally would use executemany(). I'm just wondering if I have
to have to account for it in an execute() call.

mail:   gerhard <at> bigfoot <dot> de       registered Linux user #64239
web:    http://www.cs.fhm.edu/~ifw00065/    OpenPGP public key id AD24C930
public key fingerprint: 3FCC 8700 3012 0A9E B0C9  3667 814B 9CAA AD24 C930
reduce(lambda x,y:x+y,map(lambda x:chr(ord(x)^42),tuple('zS^BED\nX_FOY\x0b')))