pgsql: timestamptz_trunc() should only recalculate the timezone when - Mailing list pgsql-committers

From tgl@svr1.postgresql.org (Tom Lane)
Subject pgsql: timestamptz_trunc() should only recalculate the timezone when
Date
Msg-id 20041101220039.0E16B3A46CD@svr1.postgresql.org
Whole thread Raw
List pgsql-committers
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)

pgsql-committers by date:

Previous
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql: Invent pg_next_dst_boundary() and rewrite
Next
From: momjian@svr1.postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Add comment about memory failure of get_progname exiting the