[DB-SIG] using stored functions in postgres with pgdb module how?

[Federico Di Gregorio]

Lì domenica, 2004/05/30 alle 18:34, -0500, rrk ha scritto:
> does any one know the syntax for calling a stored function in postgres 
> thru pgdb python package

if it has execute (and must have) you just do:

  curs.execute("SELECT stored_procedure(%s, %s, ...)", (param1, param2))

or the right param style for your database driver.

federico

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Questa parte del messaggio =?ISO-8859-1?Q?=E8?= firmata
Url : http://mail.python.org/pipermail/db-sig/attachments/20040531/bb3f98ae/attachment.bin