X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B80FFDB0E1 for ; Tue, 22 Nov 2005 14:43:01 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 94852-09 for ; Tue, 22 Nov 2005 18:43:01 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 46B94DB08A for ; Tue, 22 Nov 2005 14:42:59 -0400 (AST) Received: from amanda.contactbda.com (ipn36372-f65123.cidr.lightship.net [216.204.66.227]) by svr2.postgresql.org (Postfix) with ESMTP id 63B9BF0BC5 for ; Tue, 22 Nov 2005 18:42:59 +0000 (GMT) Received: from amanda.contactbda.com (amanda.contactbda.com [192.168.1.2]) by amanda.contactbda.com (8.12.11/8.12.11/Debian-3) with ESMTP id jAMIgrqj002394; Tue, 22 Nov 2005 13:42:53 -0500 From: "Jim Buttafuoco" To: Yves Vindevogel , pgsql-performance@postgresql.org Reply-To: jim@contactbda.com Subject: Re: Stored Procedure Date: Tue, 22 Nov 2005 13:42:53 -0500 Message-Id: <20051122184119.M48526@contactbda.com> In-Reply-To: References: X-Mailer: Open WebMail 2.41 20040926 X-OriginatingIP: 192.168.1.1 (jim) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/451 X-Sequence-Number: 15708 create function abc() returns setof RECORD ... then to call it you would do select * from abc() as (a text,b int,...); ---------- Original Message ----------- From: Yves Vindevogel To: pgsql-performance@postgresql.org Sent: Tue, 22 Nov 2005 19:29:37 +0100 Subject: [PERFORM] Stored Procedure > Is there another way in PG to return a recordset from a function than > to declare a type first ? > > create function fnTest () returns setof > myDefinedTypeIDontWantToDefineFirst ... > > Met vriendelijke groeten, > Bien à vous, > Kind regards, > > Yves Vindevogel > Implements ------- End of Original Message -------