a beginner
| From: | Pax | 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.