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