Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id BD8D8632CBB for ; Thu, 22 Oct 2009 08:41:04 -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 03003-09 for ; Thu, 22 Oct 2009 11:40:57 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from relay.ptn-ipout02.plus.net (relay.ptn-ipout02.plus.net [212.159.7.36]) by mail.postgresql.org (Postfix) with ESMTP id 20CAB6321BE for ; Thu, 22 Oct 2009 08:40:56 -0300 (ADT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: ApoEAKvh30rUnw4S/2dsb2JhbADbQIQ/BA Received: from pih-relay05.plus.net ([212.159.14.18]) by relay.ptn-ipout02.plus.net with ESMTP; 22 Oct 2009 12:40:55 +0100 Received: from [84.51.143.99] (helo=server3.office.archonet.com) by pih-relay05.plus.net with esmtp (Exim) id 1N0w2J-0006wD-8S; Thu, 22 Oct 2009 12:40:55 +0100 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTPA id 0706D410008; Thu, 22 Oct 2009 12:40:55 +0100 (BST) Message-ID: <4AE044C6.8010306@archonet.com> Date: Thu, 22 Oct 2009 12:40:54 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.23 (X11/20090817) MIME-Version: 1.0 To: Denis BUCHER CC: pgsql-sql@postgresql.org Subject: Re: Problem with return type of function ??? References: <4AE042AF.9020507@hsolutions.ch> In-Reply-To: <4AE042AF.9020507@hsolutions.ch> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Plusnet-Relay: ceaa3ede024bb3a865657704b8cba209 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/95 X-Sequence-Number: 33294 Denis BUCHER wrote: > > ERREUR: wrong record type supplied in RETURN NEXT > CONTEXTE : PL/pgSQL function "hds_bw_find_sn_live" line 26 at return next > > Does someone maybe knows what it could be ? > > This is (a part of) my function : > >> CREATE OR REPLACE FUNCTION rma.find_sn_live (varchar(30)) RETURNS SETOF rma.serial_number This is a different function. Function "hds_bw_find_sn_live" has the wrong type for its "return next". -- Richard Huxton Archonet Ltd