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 a function 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