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
