Re: Proposed patch: make SQL interval-literal syntax work per spec

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Proposed patch: make SQL interval-literal syntax work per spec
Дата
Msg-id 48C877EB.8010901@agliodbs.com
обсуждение исходный текст
Ответ на Re: Proposed patch: make SQL interval-literal syntax work per spec  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
> (1)  In the spec, an interval value or literal must be either
> year-month or day-time.  (I guess they didn't want to try to deal with
> the sticky issues of what it means to have an interval of, for
> example, seven months and three days -- since an interval has no sense
> of which seven months.)

Note that, for usability reasons, Karel some time ago try-partitioned 
our intervals: year-month|day-week|hour-min-sec.

--Josh



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Interesting glitch in autovacuum
Следующее
От: "Pavan Deolasee"
Дата:
Сообщение: Re: Interesting glitch in autovacuum