Re: [HACKERS] Interval subtracting

Поиск
Список
Период
Сортировка
От Markus Schaber
Тема Re: [HACKERS] Interval subtracting
Дата
Msg-id 440EC8FF.9080201@logix-tt.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Interval subtracting  (Scott Marlowe <smarlowe@g2switchworks.com>)
Ответы Re: [HACKERS] Interval subtracting  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-sql
Hi, Scott,

Scott Marlowe wrote:

>>But it isn't '-2 months, -1 day'.  I think what you are saying is what I
>>am saying, that we should make the signs consistent.
> Pretty much.  It just seems wrong to have different signs in what is
> essentially a single unit.
> 
> We don't say 42 degrees, -12 minutes when measuring arc, do we?  Then
> again, maybe some folks do.  It just seems wrong to me.

But we say "quarter to twelve", at least in some areas on this planet.

The problem is that months have different lengths. '2 months - 1 day'
can be '1 month 27 days', '1 month 28 days', '1 month 29 days' or '1
month 30 days', depending on the timestamp we apply the interval.

Markus
-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org


В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] problem with overloading the "coalesce" function
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: [HACKERS] Interval subtracting