Re: auditing in postgresql

["Merlin Moncure" <mmoncure(at)gmail(dot)com>]

On 8/31/07, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> On 8/31/07, Jeff Davis <pgsql(at)j-davis(dot)com> wrote:
> > 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.
>
> create function func() returns bool as
> $$
>   begin
>     raise notice 'log!';
>     return true;
>   end;
> $$ language plpgsql;
>
> how about this:
> create view log_yadda sa
>   select yadda where (select func());
>
> the parens around the function call force it to be evaluated as a scalar.

if you declare func() immutable, you can (maybe) remove the parens
because the planner folds the call to a constant.  This is faster in
some cases because

select yadda where true
is slightly faster than
select yadda where (select true)

I'm not completely sure this will prevent multiple executions of func
in some cases however.

merlin