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
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
Newsgroups: comp.databases.postgresql.bugs
Sent: Wednesday, September 03, 2003 1:05 AM
Subject: Re: to_timestamp not stable if date string shorter than template
> "Stacy White" <[EMAIL PROTECTED]> writes:
> > to_timestamp appears
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
On Fri, 2003-09-05 at 09:18, Bruno Wolff III wrote:
> On Wed, Sep 03, 2003 at 23:19:24 -0700,
> Ringo <[EMAIL PROTECTED]> wrote:
> > What a prick..
>
> >From observing Tom's responses here, I think this is a real question (not
> an RTFM response). If the documentation doesn't make it clear to ne
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
On Wed, Sep 03, 2003 at 23:19:24 -0700,
Ringo <[EMAIL PROTECTED]> wrote:
> What a prick..
>From observing Tom's responses here, I think this is a real question (not
an RTFM response). If the documentation doesn't make it clear to new readers
that explain analyze does execute the query (though do
Jim,
first of all, this is the wrong mailing list. Use pgadmin-support for
pgadmin related questions.
The binary win32 release of pgAdmin3 is unicode enabled, which requires
Windows NT, 2000 or XP, 95 and 98 are too old.
Regards,
Andreas
---(end of broadcast)-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> Unfortunately the trigger depends on some other functions that I dind't
> have so I replaced those with string constants. I couldn't get it to fail
> with a little bit of playing around on my 7.3.4 box, however.
The functions replacement should be
13 matches
Mail list logo
