Questions:
1) If you have an index on a cacheable function, does PostgreSQL use the
index instead of calculating the results?
2) How does PostgreSQL know when to recompute the function?
Jon
On Fri, 25 Jul 2003, Elielson Fontanezi wrote:
> Thanks a lot!
>
> The complete solution is here!
>
> 1s
L PROTECTED]
SDF Public Access UNIX System - http://sdf.lonestar.org
On Wed, 16 May 2001, Tom Lane wrote:
> Jonathan Bartlett <[EMAIL PROTECTED]> writes:
> > However, the only way I can see to implement this is to have session
> > global variables. Is there a way to fake session g
Is there a way to set a session global variable in PostgreSQL? The only
thing I see are examples of setting config variables. What I would like
to do is this:
Have a table "insertedby" or something that has
created_object oid,
created_by_user oid,
creation_date datetime
Then have a procedure,
