Re: bug?

Just looks like to me that a non-qualified addition of one to a date data
type increments by one day and a non-qualified interval increments by seconds
(it's easier to strip off all the other junk in the query and just look at
what your date calculation is returning):

steve=# select '2002-12-06'::date + 1;
  ?column?
------------
 2002-12-07

steve=# select '2002-12-06'::date + 1::interval;
        ?column?
------------------------
 2002-12-06 00:00:01-08

steve=# select '2002-12-06'::date + '1 day'::interval;
        ?column?
------------------------
 2002-12-07 00:00:00-08


Cheers,
Steve



On Friday 06 December 2002 4:32 pm, Laurette Cisneros wrote:
> 2002-12-06'::date + 1