Re: Error with returning SETOF Record

On Sat, 27 Dec 2003, A E wrote:

> Hi,
>  
> I was wondering if a solution was ever found to the error: "wrong record type supplied in RETURN NEXT" when executing
afunction that returns the Record datatype? I have seen a couple of previous post from Tom Lane and others, but no real
resolution.
>  
> I am attempting to execute this code and I get that error:
>  
> <code>
> CREATE FUNCTION tester(varchar) RETURNS SETOF record as'
> DECLARE
> ft record;
> begin
>       FOR ft IN SELECT * FROM visaapplicants LOOP
>           RETURN NEXT ft;
>       END LOOP;
> return null;

You have to write only return!


> end;'
>   LANGUAGE 'plpgsql' VOLATILE;
>  
Regards Pavel