Skip site navigation (1) Skip section navigation (2)

BUG #1871: operations with data types

From: "" <anris(at)polynet(dot)lviv(dot)ua>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1871: operations with data types
Date: 2005-09-09 12:00:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1871
Logged by:          
Email address:      anris(at)polynet(dot)lviv(dot)ua
PostgreSQL version: 7-8
Operating system:   Linux
Description:        operations with data types

May be it is not bug, but anywhere:

here you are sample query 
select '2005-08-31'::date + '1 month'::interval-'1 month'::interval

from the mathematical me the resulting value should be '2005-08-31', but

can you explain this


pgsql-bugs by date

Next:From: al979663Date: 2005-09-09 15:13:19
Subject: Error Failed to create process: 2! with Installer
Previous:From: Arjen van der MeijdenDate: 2005-09-09 08:52:47
Subject: Race-condition with failed block-write?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group