Bug report

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Phil Rutschman
Your email address : machack(at)rsnsoft(dot)com

System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Celeron

Operating System (example: Linux 2.0.26 ELF) : Linux 2.3.18 ELF

PostgreSQL version (example: PostgreSQL-6.5.1): PostgreSQL-6.5.1

Compiler used (example: gcc 2.8.0) : egcs-2.91.66

Please enter a FULL description of your problem:
------------------------------------------------
Dates including both a timezone offset and a timezone identifier fail parse
as invalid dates.

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
select datetime('Sat, 2 Oct 1999 01:29:48 -0700 (MST)'::text) from some_table;
ERROR: Bad datetime external representation

although both of the following work:
select datetime('Sat, 2 Oct 1999 01:29:48 -0700'::text) from some_table;
select datetime('Sat, 2 Oct 1999 01:29:48 (MST)'::text) from some_table;

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
As long as the supplied offset and timezone identifier are consistent,
there seems no reason not to allow both.

----------------------------------------------------------------------
| Phil Rutschman Math & CS Major, Western Washington Univ. |
| mailto:machack(at)rsnsoft(dot)com http://www.rsnsoft.com/~machack/ |
----------------------------------------------------------------------
Miranda paused at the antibacterial soap. Would using it create a
more resilient strain of bacteria? Should she chance it, endangering
the free world, or just wipe the cheetos dust on her jeans?