On Tue, 2004-03-02 at 20:43, Andrew Piskorski wrote: > Um, just what "stored procedures" are you talking about here? Where > are these examples or docs that you're looking at? This has nothing > to do with ODBC per-se, right? The only "stored procedures" I know > about are stuff like Oracle PL/SQL functions and procedures, and the > equivalent in PostgreSQL. >
ODBC has a stored procedure API, essentially this is similar to the ns_db sp_* API. > AOLserver's ns_db API has sp_start, ... > Hm, I think the (external) Sybase driver does use it, but nssybpd.c > says: > > * Ns_PdDbSpStart - ... > So maybe that sp_* stuff is obsolete? There might still be advantages to using them, but I didn't know pg would return rows from a function. Maybe stored procedures are safer than using dml? The AOLserver docs seem to imply this, but I think AOL is the only one using (or used to use) sp's. It is one way of providing an abstraction away from the tcl layer, so two dbs could look more similar. tom jackson -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
