Re: pgsql-server/src/backend/utils/adt datetime.c

Sean Chittenden <sean@chittenden.org> writes:
> I think this closes bug #630 as well (inserting data at 2am on a
> timzone shit).  -sc

That would be cool.  I don't have a freebsd machine to try it on though;
can you check CVS tip and see?

FWIW, I get

regression=# select timestamptz '2002-4-7 2:0:0.0';
      timestamptz
------------------------
 2002-04-07 03:00:00-04
(1 row)

but I got that (on HPUX) before the change too.  I think it's correct
--- essentially, given an "impossible" time in the spring-forward gap,
we choose to assume that it is meant as local standard time.  (In the
other case at fall-back boundaries, an ambiguous time is likewise
taken as standard time not DST.)

            regards, tom lane