Re: Possible bug in date(timestamptz)? - Mailing list pgsql-general

From dev@archonet.com
Subject Re: Possible bug in date(timestamptz)?
Date
Msg-id 49178.192.168.1.32.1048801128.squirrel@mainbox.archonet.com
Whole thread Raw
In response to Re: Possible bug in date(timestamptz)?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> Richard Huxton <dev@archonet.com> writes:
>> I can't think why one would be immutable and the other not,
>
> You aren't thinking hard enough, then :-(
>
> date(timestamptz) depends on the TimeZone setting, the other does not.

I thought immutable was for the length of a statement. Reading it, I see
that "stable" covers that. Timestamp without time zone it is then.

Thanks Tom

- Richard Huxton


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: DeleteTransactionInProgress
Next
From: Haroldo Stenger
Date:
Subject: Re: [HACKERS] Solution to UPDATE...INSERT problem