Re: Problem with return type of function ???

From: Richard Huxton <dev(at)archonet(dot)com>
To: Denis BUCHER <dbucherml(at)hsolutions(dot)ch>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Problem with return type of function ???
Date: 2009-10-22 11:40:54
Message-ID: 4AE044C6.8010306@archonet.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Denis BUCHER 2009-10-22 11:49:11 Re: Problem with return type of function ???
Previous Message Denis BUCHER 2009-10-22 11:31:59 Problem with return type of function ???