Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1N2aux51662 for ; Thu, 22 Feb 2001 21:36:56 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1I81Fx10471 for ; Sun, 18 Feb 2001 03:01:15 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f1I7dD248788 for pgsql-sql@postgresql.org; Sun, 18 Feb 2001 02:39:13 -0500 (EST) (envelope-from news) From: "John Taves" X-Newsgroups: comp.databases.postgresql.sql Subject: Can a function return a record set? Date: Sat, 17 Feb 2001 23:39:07 -0800 Lines: 21 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Message-ID: <3a8f7b37_1@news.nwlink.com> Organization: Northwest Link X-Authenticated-User: jtaves To: pgsql-sql@postgresql.org X-Archive-Number: 200102/343 X-Sequence-Number: 1539 Am I correct in concluding that I can't return a record set from a function? For example, in MS SQL I would do: create procedure foo as select * from yada I expected to be able to do the following in postgresql. create function foo (integer) returns (integer) as ' begin select * from yada; end; ' language 'plpgsql'; I am concluding that I can't. jt