]> granicus.if.org Git - postgresql/commit
Fix the various forms of AT TIME ZONE to accept either timezones found
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 9 Sep 2005 02:31:50 +0000 (02:31 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 9 Sep 2005 02:31:50 +0000 (02:31 +0000)
commita239af02c3585f4355737230bc54902e8217f76e
tree0b14018187b6cd72bc07d0212b8089566dffa9dd
parent48123de71792c367313542883f0e9df7d850c994
Fix the various forms of AT TIME ZONE to accept either timezones found
in the zic database or zone names found in the date token table.  This
preserves the old ability to do AT TIME ZONE 'PST' along with the new
ability to do AT TIME ZONE 'PST8PDT'.  Per gripe from Bricklen Anderson.
Also, fix some inconsistencies in usage of TZ_STRLEN_MAX --- the old
code had the potential for one-byte buffer overruns, though given
alignment considerations it's unlikely there was any real risk.
doc/src/sgml/datetime.sgml
doc/src/sgml/func.sgml
src/backend/utils/adt/date.c
src/backend/utils/adt/timestamp.c
src/include/pgtime.h
src/timezone/pgtz.c