Re: Top five challenges

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;