Re: Timezone issue - Is it me or is this a massive bug? - Mailing list pgsql-general

Collin Peters escribió:
> I have read the post and understand the issue.  I am wondering why
> this is not mentioned in the documentation.  Or even worse why the
> PostgreSQL documentation explicitly lists all the timezones correctly
> in table B-4 http://www.postgresql.org/docs/8.1/static/datetime-keywords.html#DATETIME-TIMEZONE-INPUT-TABLE
>
> In that table it has Melbourne, Australia as
> LIGT    +10:00    Melbourne, Australia
>
> But according to the post you linked to that is not correct... I must
> instead specifiy -10:00.  Should the documentation not note this?

Absolutely.  Care to submit a patch?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support