Received: from one.net.au (darkblue.one.net.au [203.101.17.162]) by hub.org (8.10.1/8.10.1) with SMTP id e78E9HG97135 for ; Tue, 8 Aug 2000 10:09:18 -0400 (EDT) Received: (qmail 27273 invoked from network); 8 Aug 2000 14:08:57 -0000 Received: from async63-syd-isp-235.nas.one.net.au (HELO darthvader.e-magine.com.au) (61.12.13.64) by darkblue.one.net.au with SMTP; 8 Aug 2000 14:08:57 -0000 Message-Id: <4.3.2.7.0.20000809002702.00af31d8@mail.e-magine.com.au> X-Sender: e-magine@mail.e-magine.com.au X-Mailer: QUALCOMM Windows Eudora Version 4.3.2 Date: Wed, 09 Aug 2000 00:29:50 +1000 To: pgsql-sql@postgresql.org From: Keith Wong Subject: returning a recordset with pl/pgsql Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200008/64 Hi everyone, I'm using postgresql with php4. I wanted to write a stored procedure to return a recordset (using pl/pgsql). From what I've read from the documentation it seems like you can only returned postgres types like strings, booleans, etc. Is it possible to return recordsets using pl/pgsql? If so, how do I declare the return type in the declaration? Thanks in advance. Cheers, Keith.