Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id A28FC6321BE for ; Thu, 22 Oct 2009 08:49:28 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 37631-06 for ; Thu, 22 Oct 2009 11:49:11 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from cirrus.hsolutions.ch (cirrus.hsolutions.ch [212.203.66.103]) by mail.postgresql.org (Postfix) with ESMTP id 129C1632CDF for ; Thu, 22 Oct 2009 08:49:18 -0300 (ADT) Received: from [192.168.32.120] (unknown [78.234.64.238]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by cirrus.hsolutions.ch (Postfix) with ESMTPSA id 09301880003; Thu, 22 Oct 2009 13:54:08 +0200 (CEST) Message-ID: <4AE046B7.5070805@hsolutions.ch> Date: Thu, 22 Oct 2009 13:49:11 +0200 From: Denis BUCHER Organization: Horus Digital Solutions =?ISO-8859-1?Q?S=E0rl?= User-Agent: Thunderbird 2.0.0.23 (Windows/20090812) MIME-Version: 1.0 To: Richard Huxton CC: pgsql-sql@postgresql.org Subject: Re: Problem with return type of function ??? References: <4AE042AF.9020507@hsolutions.ch> <4AE044C6.8010306@archonet.com> In-Reply-To: <4AE044C6.8010306@archonet.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.493 tagged_above=-10 required=5 tests=AWL=0.106, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200910/96 X-Sequence-Number: 33295 Richard Huxton a écrit : >> 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". Hello, Thanks a lot for your reply : the difference in name is just a mistake in my email but in fact it is the same function, I just renamed it wrong when doing the "cleaning" before posting my email... Denis