Received: from www-uk-05.digiserve.com ([195.172.23.63]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1QG5Xx97240 for ; Mon, 26 Feb 2001 11:05:34 -0500 (EST) (envelope-from dev@archonet.com) Received: from mainbox.archonet.com (mwynhau.demon.co.uk [193.237.186.96]) by www-uk-05.digiserve.com (8.9.1/8.9.1) with ESMTP id QAA15044; Mon, 26 Feb 2001 16:06:33 GMT Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id 5A1542A45C; Mon, 26 Feb 2001 15:39:29 +0000 (GMT) Message-ID: <003701c0a00a$4dca6200$1001a8c0@archonet.com> From: "Richard Huxton" To: "Qiqi Dong" , References: <97d6tq$meh$1@news.tht.net> <002e01c0a007$72e06e20$5a41a8c0@frontier> Subject: Re: Function to return recordset Date: Mon, 26 Feb 2001 15:39:22 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200102/402 X-Sequence-Number: 1607 From: "Qiqi Dong" > Hi, > > I need help! How can I get either sql or plpgsql function to return > recordset? > > Thanks, > Qiqi If you have a table foo you can define your function with "returns foo" but you cannot use this like: select foo_function('x'); At present it is only useful for use by other functions (I believe). I think Tom said this is on the developer todo list though, so sometime after 7.1 it should be possible. - Richard Huxton