Re: Top five challenges - Mailing list pgsql-advocacy

From silly sad
Subject Re: Top five challenges
Date
Msg-id 4D6F7501.30904@bestmx.ru
Whole thread Raw
In response to Re: Top five challenges  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-advocacy
On 03/02/11 17:07, Alvaro Herrera wrote:
> Excerpts from sad's message of mié mar 02 10:23:53 -0300 2011:
>> On Mar 2 2011, Josh Berkus wrote:
>
>>>> 3. To make TIMESTAMPTZ useful by introducing proper type cast
>>>> TIMESTAMPTZ to TIMESTAMP
>>>
>>> Why are you using Timestamp-no-tz at all?  I was thinking we should
>>> change the default ...
>>
>> Why did u introduced it?
>
> The standard requires the current behavior.  It's not going to change.
> It changed in 7.1 or so.
>

does standard require to have TWO DIFFERENT EPOCHS?

SELECT 'epoch'::TIMESTAMPTZ, 'epoch'::TIMESTAMP;

pgsql-advocacy by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Top five challenges
Next
From: Josh Berkus
Date:
Subject: Re: Top five challenges