]> granicus.if.org Git - postgresql/commit
This patch makes it possible to use the full set of timezones when doing
authorBruce Momjian <bruce@momjian.us>
Wed, 15 Jun 2005 00:34:11 +0000 (00:34 +0000)
committerBruce Momjian <bruce@momjian.us>
Wed, 15 Jun 2005 00:34:11 +0000 (00:34 +0000)
commit0851a6fbc77e7f1762a2a94d370492f03450e922
tree13fc854cd326b9d6cc118fc989a6aff5a3e60990
parent5955945828d96511798c3edf158ff2c341257d19
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
doc/src/sgml/datetime.sgml
doc/src/sgml/func.sgml
src/backend/utils/adt/date.c
src/backend/utils/adt/formatting.c
src/backend/utils/adt/nabstime.c
src/backend/utils/adt/timestamp.c
src/include/pgtime.h
src/include/utils/timestamp.h
src/timezone/pgtz.h