Re: Re: Data type confusion

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Re: Data type confusion
Дата
Msg-id Pine.LNX.4.30.0108060157170.11162-100000@peter.localdomain
обсуждение исходный текст
Ответ на Re: Re: Data type confusion  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Re: Data type confusion
Список pgsql-sql
Tom Lane writes:

> It is kinda bogus, given the underlying semantics of intervals
> (integer months plus float seconds).

> This is pretty grotty, and AFAIK not documented anywhere --- I found it
> out by looking at the C code for these operators.  But I'm not sure
> how to do better.

One day we will have to accept the fact that months and seconds must not
be mixed, period.  You can have year/month intervals or
day/hour/minute/second intervals, not a combination.  An interval of '5
years 3 minutes' has no meaning with the natural calendar rules.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: Data type confusion
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Re: Data type confusion