Re: Consistency problem with unlabeled intervals

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Consistency problem with unlabeled intervals
Дата
Msg-id 2897.1020391306@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Consistency problem with unlabeled intervals  (Thomas Lockhart <lockhart@fourpalms.org>)
Список pgsql-hackers
Thomas Lockhart <lockhart@fourpalms.org> writes:
>> That is, '60' is read as so many hours, '1.5' is read as so many
>> seconds.  This seems a tad inconsistent.

> They fulfill two separate use cases. Time zones can now be specified as
> intervals, and the default unit must be hours. A number with a decimal
> point is usually in units of seconds, and matches past behavior afaik.

Hm.  Well, if this behavior is intentional, it'd be nice to document it.
The existing paragraphs about interval's I/O format don't mention
behavior for unitless numbers at all, much less explain that a decimal
point has semantic significance.
        regards, tom lane


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

Предыдущее
От: mlw
Дата:
Сообщение: Re: PostgreSQL mission statement?
Следующее
От: Jim Mercer
Дата:
Сообщение: Re: PostgreSQL mission statement?