On Thu, 2007-08-30 at 21:43 -0400, Merlin Moncure wrote:
> Well, a SRF may be unsuitable for various reasons, but maybe views are
> better. I really like views more and more lately (better than
> functions as a rule, I think).
>
> you have some query, select yadda
> create view log_yadda as
> select yadda
> union all select null, null, null from log_func();
>
Interesting idea, I hadn't thought of that. Not perfect, but
interesting.
The "returns query" might help reduce the penalty of using a SRF. Maybe
I'll look into that.
Regards,
Jeff Davis