Skip site navigation (1) Skip section navigation (2)

pgsql: This patch makes it possible to use the full set of timezones

From: momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: This patch makes it possible to use the full set of timezones
Date: 2005-06-15 00:34:13
Message-ID: 20050615003413.9E78A5290D@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
This patch makes it possible to use the full set of timezones when doing
"AT TIME ZONE", and not just the shorlist previously available. For
example:

SELECT CURRENT_TIMESTAMP AT TIME ZONE 'Europe/London';

works fine now. It will also obey whatever DST rules were in effect at
just that date, which the previous implementation did not.

It also supports the AT TIME ZONE on the timetz datatype. The whole
handling of DST is a bit bogus there, so I chose to make it use whatever
DST rules are in effect at the time of executig the query. not sure if
anybody is actuallyi *using* timetz though, it seems pretty
unpredictable just because of this...

Magnus Hagander

Modified Files:
--------------
    pgsql/doc/src/sgml:
        datetime.sgml (r2.45 -> r2.46)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/datetime.sgml.diff?r1=2.45&r2=2.46)
        func.sgml (r1.256 -> r1.257)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml.diff?r1=1.256&r2=1.257)
    pgsql/src/backend/utils/adt:
        date.c (r1.109 -> r1.110)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/date.c.diff?r1=1.109&r2=1.110)
        formatting.c (r1.87 -> r1.88)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/formatting.c.diff?r1=1.87&r2=1.88)
        nabstime.c (r1.132 -> r1.133)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/nabstime.c.diff?r1=1.132&r2=1.133)
        timestamp.c (r1.125 -> r1.126)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/timestamp.c.diff?r1=1.125&r2=1.126)
    pgsql/src/include:
        pgtime.h (r1.7 -> r1.8)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/pgtime.h.diff?r1=1.7&r2=1.8)
    pgsql/src/include/utils:
        timestamp.h (r1.44 -> r1.45)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/timestamp.h.diff?r1=1.44&r2=1.45)
    pgsql/src/timezone:
        pgtz.h (r1.11 -> r1.12)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/pgtz.h.diff?r1=1.11&r2=1.12)

pgsql-committers by date

Next:From: Bruce MomjianDate: 2005-06-15 00:35:16
Subject: pgsql: > Here's a patch I added against plperl, originally against
Previous:From: Bruce MomjianDate: 2005-06-15 00:15:08
Subject: pgsql: Support 3 and 4-byte unicode characters.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group