September 05, 2003 2:32 PM
> To: Stephan Szabo
> Cc: Daniel Schreiber; [EMAIL PROTECTED]
> Subject: Re: [BUGS] Unclear documentation (IMMUTABLE functions)
>
>
> On Fri, 2003-09-05 at 10:01, Stephan Szabo wrote:
> > This is the section in create function reference page about
>
Neil Conway <[EMAIL PROTECTED]> writes:
> While we're on the subject, this adjacent paragraph of the docs seems
> unclear:
> STABLE indicates that within a single table scan the function
> will consistently return the same result for the same argument
> values, but that its
On Fri, 2003-09-05 at 10:01, Stephan Szabo wrote:
> This is the section in create function reference page about immutable. I'd
> thought it was clear, but do you have a better suggested wording?
While we're on the subject, this adjacent paragraph of the docs seems
unclear:
STABLE indicate
Daniel Schreiber <[EMAIL PROTECTED]> writes:
> Okay, thanks for the help. I will rewrite the function as STABLE. Btw: is
> there documentation which parts in the environment are STABLE/IMMUTABLE?
Look in pg_proc (the provolatile column is 'i', 's', or 'v' IIRC).
I don't think psql's \df will show
Am Freitag, 5. September 2003 17:05 schrieb Tom Lane:
> Daniel Schreiber <[EMAIL PROTECTED]> writes:
> > A question on IMMUTABLE functions: do they only have to return the same
> > value during a session/connection or during the databse server's
> > lifetime?
>
> Lifetime, I'd say, since among othe
Am Freitag, 5. September 2003 16:01 schrieb Stephan Szabo:
> On Fri, 5 Sep 2003, Daniel Schreiber wrote:
> > Hi,
> >
> > A question on IMMUTABLE functions: do they only have to return the same
> > value during a session/connection or during the databse server's
> > lifetime? The documentation does
Daniel Schreiber <[EMAIL PROTECTED]> writes:
> A question on IMMUTABLE functions: do they only have to return the same value
> during a session/connection or during the databse server's lifetime?
Lifetime, I'd say, since among other things IMMUTABLE is considered to
mean that it's okay to build an
On Fri, 5 Sep 2003, Daniel Schreiber wrote:
> Hi,
>
> A question on IMMUTABLE functions: do they only have to return the same value
> during a session/connection or during the databse server's lifetime? The
> documentation does not say anything about that.
The function should always return the sa
Hi,
A question on IMMUTABLE functions: do they only have to return the same value
during a session/connection or during the databse server's lifetime? The
documentation does not say anything about that.
I wrote a function that uses the CURRENT_USER session variable, and for my
current usage it
