Re: plpgsql function returning SETOF - Mailing list pgsql-novice

"Johannes Br�gmann" <johannes@jottbee.org> writes:
> sorry, i missed the error message:

>       bruegmann@traffic_nrw=# select feiertage(NULL);
>       ERROR:  set-valued function called in context that cannot accept a set
>       CONTEXT:  PL/pgSQL function "feiertage" line 30 at return next

You need to do
    select * from your_function(...);
not just
    select your_function(...);

            regards, tom lane