Thread

1. Strange results with interval types computations

   PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2001-01-14T16:58:13Z

   Laurent HERVE (laurent_herve@infonie.fr) reports a bug with a severity of 3
   The lower the number the more severe it is.
   
   Short Description
   Strange results with interval types computations
   
   Long Description
   Look at those two queries :
   
   ez_money=> select '10/01/2000'::date+'1 month'::interval;
   ?column?
   ----------------------
   2000-10-31 23:00:00+01
   (1 row)
    
   ez_money=> select '09/01/2000'::date+'1 month'::interval;
   ?column?
   ----------------------
   2000-10-01 00:00:00+02
   (1 row)                        
   
   Strange that 10/01/2000 + 1 month does not give 11/01/2000 !
   
   Sample Code
   
   
   No file was uploaded with this report
   
   
   

2. Re: Strange results with interval types computations

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-01-14T17:14:22Z

   pgsql-bugs@postgresql.org writes:
   > ez_money=> select '10/01/2000'::date+'1 month'::interval;
   > ?column?
   > ----------------------
   > 2000-10-31 23:00:00+01
   > (1 row)
   
   DST transition problem.  It's fixed in current sources.
   
   			regards, tom lane