Steve Rogerson <steve.pg@xxxxxxxxxxxxxxxxx> writes: > I wonder what counts as a valid time zone http://www.postgresql.org/docs/9.5/static/datatype-datetime.html#DATATYPE-TIMEZONES > ... I wasn't expecting this: > # set timezone = '==2.77'; > SET > # select now(); > now > ------------------------------- > 2016-04-18 09:40:52.089375-77 > (1 row) Postgres is *very* lax about what is a valid timezone abbreviation in the POSIX notation, mainly because the underlying Olson code is too. I think it's taking that as '==' being the standard zone abbreviation and '.' being the DST zone abbreviation. If you wanted to restrict input to be the Olson-style zone names, you could do some kind of precheck, maybe insist on only letters/ slashes/underscores. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
