Difference in DATEs - Mailing list pgsql-sql

From Dean Gibson (DB Administrator)
Subject Difference in DATEs
Date
Msg-id 5.1.0.14.2.20040921003212.00a958d8@postgresql3.ultimeth.com
Whole thread Raw
Responses Re: Difference in DATEs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Assume that x and y are of type DATE:

1. AGE( x, y ) < INTERVAL '...' works.

2. x < y + INTERVAL '...' works.

3. x - y < INTERVAL '...' doesn't work (but then, the minus operator is not 
defined in the manual for two DATE values).

Question:  Is the meaning of x - y well-defined?  That is, is there a 
definition that I can count on?

Not an important question, but I'm curious, since I like to write date 
differences in a style that makes readability/maintenance easy.

-- Dean



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: JOIN performance
Next
From: "Alain Reymond"
Date:
Subject: degradation in performance