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

From: Sean Chittenden <sean(at)chittenden(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql-server/src/backend/utils/adt datetime.c
Date: 2002-09-05 21:00:39
Message-ID: 20020905210039.GK59269@ninja1.internal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2002-09-05 21:01:16 pgsql-server/contrib/pg_dumplo lo_export.c lo_ ...
Previous Message Tom Lane 2002-09-05 20:57:00 pgsql-server/contrib/dbase dbf.c