Re: plpgsql function returning SETOF

Hello Tom,
hello novices and experts,

Tom Lane  writes:

> "Johannes Brügmann"  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