Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 87B30632A88 for ; Thu, 22 Oct 2009 12:06:56 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 31049-04 for ; Thu, 22 Oct 2009 15:06:49 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from relay.pcl-ipout01.plus.net (relay.pcl-ipout01.plus.net [212.159.7.99]) by mail.postgresql.org (Postfix) with ESMTP id C93B7633DC1 for ; Thu, 22 Oct 2009 12:06:48 -0300 (ADT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: ApoEAMER4EpUXebq/2dsb2JhbADcEoQ/BA Received: from relay07.plus.net (HELO fhw-relay07.plus.net) ([84.93.230.234]) by relay.pcl-ipout01.plus.net with ESMTP; 22 Oct 2009 16:06:48 +0100 Received: from [84.51.143.99] (helo=server3.office.archonet.com) by fhw-relay07.plus.net with esmtp (Exim) id 1N0zFX-0001tU-JV; Thu, 22 Oct 2009 16:06:47 +0100 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTPA id 5CB56410008; Thu, 22 Oct 2009 16:06:47 +0100 (BST) Message-ID: <4AE07507.5050900@archonet.com> Date: Thu, 22 Oct 2009 16:06:47 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.23 (X11/20090817) MIME-Version: 1.0 To: Tom Lane CC: Denis BUCHER , pgsql-sql@postgresql.org Subject: Re: Problem with return type of function ??? (corrected) References: <4AE046E4.8010205@hsolutions.ch> <29935.1256222015@sss.pgh.pa.us> In-Reply-To: <29935.1256222015@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Plusnet-Relay: abba4ca3158b990e3a8ff0b3f63c4a4a X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-3.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599, RCVD_IN_DNSWL_LOW=-1 X-Spam-Level: X-Archive-Number: 200910/107 X-Sequence-Number: 33306 Tom Lane wrote: > Denis BUCHER writes: > > Does that table have any dropped columns? If you don't remember > whether you ever dropped any columns, a quick look into pg_attribute > will tell you: > select attname from pg_attribute where attrelid = 'rma.serial_number'::regclass; > > plpgsql isn't tremendously good with rowtypes that contain dropped > columns. I thought that only applied to columns dropped after the function was defined. Live and learn. -- Richard Huxton Archonet Ltd