Patch applied. Thanks. Doc updates applied too. ---------------------------------------------------------------------------
Magnus Hagander wrote: > 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... > > Docs updates forthcoming assuming this approach is considered good ;-) > > //Magnus Content-Description: timezones.patch [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org