Re: Why extract( ... from timestamp ) is not immutable? - Mailing list pgsql-general

From Tom Lane
Subject Re: Why extract( ... from timestamp ) is not immutable?
Date
Msg-id 28307.1327506239@sss.pgh.pa.us
Whole thread Raw
In response to Re: Why extract( ... from timestamp ) is not immutable?  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: Why extract( ... from timestamp ) is not immutable?  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-general
hubert depesz lubaczewski <depesz@depesz.com> writes:
> how can I then have immutable epoch for given point in time?

What do you consider to be "a given point in time"?  It seems like
you have not thought through what effects the timezone setting has
on your concept of "now", or at least you have not explained what
you need.

Perhaps even more to the point, why aren't you just storing the
timestamp or timestamptz value and being happy with that?

            regards, tom lane

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Why extract( ... from timestamp ) is not immutable?
Next
From: Adrian Klaver
Date:
Subject: Re: Why extract( ... from timestamp ) is not immutable?