Re: Bug in date arithmetic - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Bug in date arithmetic
Date
Msg-id 4A933E95.5050909@agliodbs.com
Whole thread Raw
In response to Re: Bug in date arithmetic  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom,

> we preferentially consider unknown_literal to be of the same type
> as the other operand.

I can't really think of what other assumption we would make.  Any time a
user doesn't specify a type, they're taking pot luck.

Me, I always use some_timestamp + INTERVAL 'value' ....

-- 
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com


pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Bug in visibility hint bit
Next
From: Josh Berkus
Date:
Subject: Re: DELETE syntax on JOINS