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)
commit3193ddaccfec36a5777d33a4661164a79f9eaae5
tree637e6c978c8677792f60a315c1cd97c726cf6a0c
parent3210839b0640986286dff36931686234da7632c3
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