Re: auditing in postgresql

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