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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
