timestamptz parsing bug?

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: timestamptz parsing bug?
Date: 2011-08-29 14:40:58
Message-ID: 4E5BA4FA.6080801@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Why do we parse this as a correct timestamptz literal:

2011-08-29T09:11:14.123 CDT

but not this:

2011-08-29T09:11:14.123 America/Chicago

Replace the ISO-8601 style T between the date and time parts of the
latter with a space and the parser is happy again.

cheers

andrew

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Shigeru Hanada 2011-08-29 14:54:41 Join push-down for foreign tables
Previous Message Robert Haas 2011-08-29 14:20:18 Re: spinlocks on HP-UX