Re: plpgsql function returning SETOF

Hello Tom,
hello novices and experts,

Tom Lane <tgl@sss.pgh.pa.us> writes:

> "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(...);

yes, that's it! Now it works, yeaaaah!

Thanks a lot to you, Tom, for your immediate help!
Johannes