I am new to PHP/Postgres. I come from an ASP/(ADO)/MSSQL environment and I
have problems figuring out how to do things that are quite simple there.
First of all, a question that regards Postgres (I couldn't get an answer at
PG newsgroups). I understand that the PG 'synonym' for MSSQL stored
procedure is the 'function'. Am I right? Please, do not give me an equivoque
response. Is very important for me to have this topic clear to stop digging.
Second (still about PG), is there any way to have a PG function return a
multi-field, multi-row result set, just the way a simple 'select' does in a
MSSQL stored proc? What I mean is
CREATE FUNCTION f_test() RETURNS DontKnowWhat AS
'SELECT * FROM MyTable'
LANGUAGE SQL ... or maybe PLPGSQL?
Is there any way to do it?
The third question regards PHP. I understand that PHP is able to manage
bi-dimensional result sets. If PG cannot return such sets from code that is
stored on the server (stored procs/functions), then the only way to obtain
them is issuing hand-made query strings from PHP?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php