possibly a bug?

From: Ewald Geschwinde <webmaster(at)geschwinde(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: possibly a bug?
Date: 2002-01-30 23:05:31
Message-ID: 3C587C3B.6070803@geschwinde.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2002-01-30 23:27:46 Re: possibly a bug?
Previous Message Steve Boyle (Roselink) 2002-01-30 22:37:42 Re: Function Problem