Re: auditing in postgresql

[Jeff Davis <pgsql(at)j-davis(dot)com>]

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