Re: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12

Поиск
Список
Период
Сортировка
От Arnold Mavromatis
Тема Re: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12
Дата
Msg-id C5F387003C39D411829E00D0B7496139E2821F@jetstream.ho.bom.gov.au
обсуждение исходный текст
Ответы Re: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-bugs
Hi Stephan and everyone

We have tried PG 7.3.4 (the bug still presents itself)

These are the following results..

Welcome to psql 7.3.4, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

db2=> select cast(timestamptz '1901/12/13' as date);
    date
------------
 1901-12-13
(1 row)

db2=> select cast(timestamptz '1901/12/14' as date);
    date
------------
 1901-12-13
(1 row)

db2=> select cast(timestamptz '1901/12/15' as date);
    date
------------
 1901-12-15
(1 row)


Compiler switches..

./configure --prefix=/adamdb/postgres/pg_admin/pgsql_7.3.4 --enable-debug
--with-pgport=5433 --without-readline --without-zlib
--enable-integer-datetimes

Everything else was left at default settings

Readline and zlib were bypassed because they are not available.

HP-UX 11.11i

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: FW: postgresql 7.3.2 bug on date '1901-12-13' and '190 1-1 2 (fwd)
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12