a beginner

From: Date: Mon, 26 Aug 2002 19:14:03 +0000
Subject: a beginner
Groups: php.db 
Request: Send a blank email to php-db+get-21374@lists.php.net to get a copy of this message
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. 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.

« previous php.db (#21374) next »