Skip site navigation (1) Skip section navigation (2)

Bug report

From: Phil Rutschman <machack(at)rsnsoft(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug report
Date: 1999-10-05 02:48:02
Message-ID: v04003a09b41f15ddb5b9@[209.180.200.26] (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-bugs
============================================================================
                        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?



pgsql-bugs by date

Next:From: Justin LongDate: 1999-10-05 14:28:40
Subject: BUG: in SELECT DISTINCT
Previous:From: Duncan KinderDate: 1999-10-04 21:44:55
Subject: Regression test failures

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group