Re: Problem with return type of function ??? - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Problem with return type of function ???
Date
Msg-id 4AE044C6.8010306@archonet.com
Whole thread Raw
In response to Problem with return type of function ???  (Denis BUCHER <dbucherml@hsolutions.ch>)
Responses Re: Problem with return type of function ???  (Denis BUCHER <dbucherml@hsolutions.ch>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Thomas Pundt
Date:
Subject: Re: @@Error equivalent in Postgresql
Next
From: Denis BUCHER
Date:
Subject: Re: Problem with return type of function ???