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

> > 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.)

Looks like this works on HEAD.  -sc

--
Sean Chittenden