possibly a bug? - Mailing list pgsql-novice

From Ewald Geschwinde
Subject possibly a bug?
Date
Msg-id 3C587C3B.6070803@geschwinde.net
Whole thread Raw
Responses Re: possibly a bug?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: possibly a bug?  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-novice
beta=# select version();
                            version
---------------------------------------------------------------
 PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.95.3
(1 row)

Is this a bug or Am i Wrong?
Or can be done this with another sql statement
I want to know only the next day of a date


beta=# SELECT ('2001-10-26'::date + '1 day'::interval)::date;
  ?column?
------------
 2001-10-27
(1 row)

beta=# SELECT ('2001-10-27'::date + '1 day'::interval)::date;
  ?column?
------------
 2001-10-28
(1 row)

beta=# SELECT ('2001-10-28'::date + '1 day'::interval)::date;
  ?column?
------------
 2001-10-28
(1 row)

Ewald Geschwinde



pgsql-novice by date:

Previous
From: "Steve Boyle \(Roselink\)"
Date:
Subject: Re: Function Problem
Next
From: Tom Lane
Date:
Subject: Re: possibly a bug?