Re: Top five challenges

On 03/10/11 19:45, Bruce Momjian wrote:
> silly sad wrote:
>> On 03/10/11 19:01, Bruce Momjian wrote:
>>> 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.
>>>
>>> And we document why the default is so odd:
>>>
>>>     http://www.postgresql.org/docs/9.0/static/datatype-datetime.html#DATATYPE-TIMEZONES
>>>
>>>     Note: The SQL standard requires that writing just timestamp be
>>>     equivalent to timestamp without time zone, and PostgreSQL honors that
>>>     behavior. (Releases prior to 7.3 treated it as timestamp with time
>>>     zone.)
>>
>> do you document why 'epoch'::timestamp is not the true 'epoch' unless
>> timezone is not GMT?
>>
>> if you mention any timestamp except 'epoch' it will be interpreted
>> correctly taking in account timezone setting.
>
> Well, 'epoch' clearly is a point in time with the hour being midnight at
> GMT, so I don't see a problem with epoch making such an adjustment:


great! the flexible epoch!

when do want to point an epoch to?
just set timezone and enjoy.