| From: | "Andrew V(dot) Gromozdin" <ag(at)dataforce(dot)net> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Month interval bug |
| Date: | 1999-10-01 13:59:34 |
| Message-ID: | 37F4BE46.ED099D96@dataforce.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Andrew V. Gromozdin
Your email address : ag(at)df(dot)ru
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium
Operating System (example: Linux 2.0.26 ELF) : Linux 2.0.38 ELF
PostgreSQL version (example: PostgreSQL-6.4.2) : PostgreSQL-6.4.2
Compiler used (example: gcc 2.8.0) : gcc 2.7.2.3
Please enter a FULL description of your problem:
------------------------------------------------
QUERY: select '09/01/1999 00:00:01.00 MSD'::datetime +
'1month'::timespan as err
or_date;
error_date
---------------------------------
Fri\ Oct\ 01\ 00:00:01\ 1999\ MSD
(1 row)
QUERY: select '09/01/1999 00:00:01.00 MSD'::datetime +
'2month'::timespan as err
or_date;
error_date
---------------------------------
Sun\ Oct\ 31\ 23:00:01\ 1999\ MSK
(1 row)
QUERY: select '09/01/1999 00:00:01.00 MSD'::datetime +
'3month'::timespan as err
or_date;
error_date
---------------------------------
Tue\ Nov\ 30\ 23:00:01\ 1999\ MSK
(1 row)
QUERY: select '09/01/1999 00:00:01.00 MSD'::datetime +
'4month'::timespan as err
or_date;
error_date
---------------------------------
Fri\ Dec\ 31\ 23:00:01\ 1999\ MSK
(1 row)
QUERY: select '09/01/1999 00:00:01.00 MSD'::datetime +
'5month'::timespan as err
or_date;
error_date
---------------------------------
Mon\ Jan\ 31\ 23:00:01\ 2000\ MSK
(1 row)
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
run this query from psql
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
I think it's because of unnormal defined MONTH interval
--
Sincerely Your
Andrew V. Gromozdin, DataForce ISP, Moscow, Russia
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jose soares | 1999-10-01 15:14:33 | Re: [GENERAL] ODBC-client->Linux-server: datatype boolean not recognized? |
| Previous Message | Moray McConnachie | 1999-09-30 15:24:58 | Re: [GENERAL] ODBC-client->Linux-server: datatype boolean not recognized? |