Interval Division Workaround Suggestions (sub-day intervals only)?

Поиск
Список
Период
Сортировка
От David Johnston
Тема Interval Division Workaround Suggestions (sub-day intervals only)?
Дата
Msg-id 006c01cd3dc3$7fe7ff00$7fb7fd00$@yahoo.com
обсуждение исходный текст
Ответы Re: Interval Division Workaround Suggestions (sub-day intervals only)?  (Chris Angelico <rosuav@gmail.com>)
Список pgsql-general

Any suggestions on how to obtain the number of “X minute” intervals in “Y” where “Y” is always less than 24 hours?

 

e.g., : ‘05:00:00’::interval / ’00:06:00’::interval => 50 (integer)

 

I am guessing because intervals cover not-well-defined (variable) periods of times (i.e., months, years) that the definition of “divided into” is not stable enough implement a general division operator for.

 

 

From the Wiki:

 

http://wiki.postgresql.org/wiki/Working_with_Dates_and_Times_in_PostgreSQL

4. Multiplication and division of INTERVALS is under development and discussion at this time

It is suggested that you avoid it until implementation is complete or you may get unexpected results.

 

Thanks!

 

David J.

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

Предыдущее
От: Michael Nolan
Дата:
Сообщение: Fwd: Disable Streaming Replication without restarting either master or slave
Следующее
От: Chris Angelico
Дата:
Сообщение: Re: Interval Division Workaround Suggestions (sub-day intervals only)?