Re: [COMMITTERS] pgsql: timestamptz_trunc() should only recalculate - Mailing list pgsql-hackers

From Devrim GUNDUZ
Subject Re: [COMMITTERS] pgsql: timestamptz_trunc() should only recalculate
Date
Msg-id Pine.LNX.4.61.0411020030500.1926@emo.org.tr
Whole thread Raw
Responses Re: [COMMITTERS] pgsql: timestamptz_trunc() should only  (Devrim GUNDUZ <devrim@gunduz.org>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

I got an error in make check now, in horology test:

http://postgresql.gunduz.org/regression.diffs

Is it related to this commit?

Regards, Devrim
On Mon, 1 Nov 2004, Tom Lane wrote:

> Log Message:
> -----------
> timestamptz_trunc() should only recalculate the timezone when truncating
> to DAY precision or coarser; leave the timezone alone when precision is
> HOUR or less.  This avoids surprises for inputs near a DST transition
> time, as per example from Matthew Gabeler-Lee.  (The only reason we
> recalculate at all is so that outputs that are supposed to represent
> days will come out as local midnight, and that's not relevant for sub-day
> precision.)
>
> Modified Files:
> --------------
>    pgsql/src/backend/utils/adt:
>        timestamp.c (r1.113 -> r1.114)
>        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/timestamp.c.diff?r1=1.113&r2=1.114)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org
>

- --
Devrim GUNDUZ 
devrim~gunduz.org                devrim.gunduz~linux.org.tr            http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFBhrpMtl86P3SPfQ4RAvtXAKCs7zWA3n8crbd5VsToKoTobHqtEQCdEw5y
mU92XW7xTLm3iC3L+jq0idA=
=Rm7E
-----END PGP SIGNATURE-----


pgsql-hackers by date:

Previous
From: Thomas Hallgren
Date:
Subject: Re: charset/collation in values
Next
From: Devrim GUNDUZ
Date:
Subject: Re: [COMMITTERS] pgsql: timestamptz_trunc() should only