Difference in DATEs

Поиск
Список
Период
Сортировка
От Dean Gibson (DB Administrator)
Тема Difference in DATEs
Дата
Msg-id 5.1.0.14.2.20040921003212.00a958d8@postgresql3.ultimeth.com
обсуждение исходный текст
Ответы Re: Difference in DATEs
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: JOIN performance
Следующее
От: "Alain Reymond"
Дата:
Сообщение: degradation in performance