Re: Difference in DATEs - Mailing list pgsql-sql

From Tom Lane
Subject Re: Difference in DATEs
Date
Msg-id 386.1095775282@sss.pgh.pa.us
Whole thread Raw
In response to Difference in DATEs  ("Dean Gibson (DB Administrator)" <postgresql3@ultimeth.com>)
List pgsql-sql
"Dean Gibson (DB Administrator)" <postgresql3@ultimeth.com> writes:
> 3. x - y < INTERVAL '...' doesn't work (but then, the minus operator is not 
> defined in the manual for two DATE values).

Sure it is: see 10th row in
http://www.postgresql.org/docs/7.4/static/functions-datetime.html#OPERATORS-DATETIME-TABLE

Forget the interval and compare to an integer.
        regards, tom lane


pgsql-sql by date:

Previous
From: Pierre-Frédéric Caillaud
Date:
Subject: Re: degradation in performance
Next
From: "CHRIS HOOVER"
Date:
Subject: Re: Help with function