Re: Error with returning SETOF Record - Mailing list pgsql-hackers

A E <cooljoint@yahoo.com> writes:
> 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;
> end;'
>   LANGUAGE 'plpgsql' VOLATILE;
> <calling query>
> select * from tester('a') as (c varchar);
> <exact error>
> ERROR:  wrong record type supplied in RETURN NEXT
> CONTEXT:  PL/pgSQL function "tester" line 6 at return next

That's pretty much what I'd expect, unless table visaapplicants contains
only a single varchar column.  The example works fine for me if I define
visaapplicants that way.
        regards, tom lane