On 08/03/2012 10:21 AM, Laszlo Nagy wrote:
I can not from the given information. Can you? The given information is
ambiguous as are all times during the hour of fall-back everywhere. That
leaves developers with a choice: choose an interpretation or throw an
error. PostgreSQL chooses to use an interpretation.
It would be nice if there were a specification as to how such ambiguous
data should be interpreted. Perhaps someone can point me to one and to
any relevant documentation detailing how PostgreSQL handles such data.
As it is, you need to be aware of how each part of your system deals
with such. For example (using my local time zone) using the date command
on Linux I see that
"date -d '2012-11-04 0130'"
"Sun Nov 4 01:30:00 PDT 2012" (Still in Daylight Saving Time)
But given the same input, PostgreSQL interprets it as standard time
select '2012-11-04 0130'::timestamptz;
So you took two distinct points in time, threw away some critical
information, and are surprised why they are now equal? Then don't do
that. It's the equivalent of being surprised that www.microsoft.com
the same as www.apple.com
when comparing them on the short hostname
only. If you want to know if two points in time differ, just compare them.
Spending a couple hours reading
will be time well spent.
Sent via pgsql-performance mailing list (pgsql-performa...@postgresql.org)
To make changes to your subscription: