Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Possible bug in date(timestamptz)?
Date
Msg-id 15538.1048793690@sss.pgh.pa.us
Whole thread Raw
In response to Possible bug in date(timestamptz)?  (Richard Huxton <dev@archonet.com>)
Responses Re: Possible bug in date(timestamptz)?  (dev@archonet.com)
List pgsql-general
Tree view 
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.

            regards, tom lane

pgsql-general by date:

Previous
From: "Vilson farias"
Date:
Subject: DeleteTransactionInProgress
Next
From: Tad Marko
Date:
Subject: Data conversion in query