Hi, there! 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.
Advertising
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? Thanks. Pax. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
