timestamp (minor bug) - Mailing list pgsql-bugs

From And. Andruikhanov
Subject timestamp (minor bug)
Date
Msg-id 20010722135456.I98532-100000@www.euinf.net
Whole thread Raw
In response to temp table in pl/pgsql language  ("And. Andruikhanov" <andy@euinf.dp.ua>)
Responses Re: timestamp (minor bug)
List pgsql-bugs
Good day.

  System Configuration
  ---------------------
    Architecture: Intel Pentium
    Operating System: FreeBSD 4.2-STABLE
    PostgreSQL version:   PostgreSQL-7.1.2
    Compiler used:  gcc 2.95.2

  Description of problem
  ----------------------

Wrong result in timestamp value between "winter" and "summer" time:

select '2001-03-24 03:00'::timestamp;
        ?column?
------------------------
 2001-03-24 03:00:00+02
(1 row)

It's OK, but another example will demonstrate error:
select '2001-03-25 03:00'::timestamp;
        ?column?
------------------------
 2035-05-22 09:58:04+03
(1 row)

NOTICE:  DateStyle is ISO with European conventions
LC_ALL=ru_RU.KOI8-R


  Best regards..
 --

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: When inserting '\' the insert fails.
Next
From: Tatsuo Ishii
Date:
Subject: Re: libpgtcl doesn't use UTF encoding of TCL