Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id A2D93634275 for ; Thu, 27 May 2010 16:29:00 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 27674-05 for ; Thu, 27 May 2010 19:28:52 +0000 (UTC) Received: from news.hub.org (news.hub.org [200.46.204.72]) by mail.postgresql.org (Postfix) with ESMTP id 5EF966327DE for ; Thu, 27 May 2010 16:28:52 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.3/8.14.3) with ESMTP id o4RJSlJU031458 for ; Thu, 27 May 2010 16:28:49 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.3/8.14.3/Submit) id o4O1FjLr038672 for pgsql-sql@postgresql.org; Sun, 23 May 2010 22:15:45 -0300 (ADT) (envelope-from news) From: jr X-Newsgroups: pgsql.sql Subject: Re: return %ROWTYPE from function Date: Mon, 24 May 2010 02:15:25 +0100 Organization: Hub.Org Networking Services Lines: 9 Message-ID: References: <0b4febda-32f3-4346-bb99-4d5197464f19@i31g2000vbt.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 2.0.0.4 (X11/20070604) In-Reply-To: <0b4febda-32f3-4346-bb99-4d5197464f19@i31g2000vbt.googlegroups.com> To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.79 tagged_above=-5 required=5 tests=BAYES_50=0.8, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201006/10 X-Sequence-Number: 34201 hi Anton, works fine if you write: create or replace function get_rec (in p_id test.id%TYPE) returns test as $$ -- regards, jr. (jr@tailorware.org.uk)