Re: Proposal: Division operator for (interval / interval => double precision)

Поиск
Список
Период
Сортировка
От Kashif Zeeshan
Тема Re: Proposal: Division operator for (interval / interval => double precision)
Дата
Msg-id CAAPsdhdurM7rKYPy17xtBsiPszN+vdobv1F6Uc5af71yXrZkrA@mail.gmail.com
обсуждение исходный текст
Ответ на Proposal: Division operator for (interval / interval => double precision)  (Gurjeet Singh <gurjeet@singh.im>)
Список pgsql-hackers
Hi

Its always a good idea to extend the functionality of PG.

Thanks
Kashif Zeeshan

On Mon, Jun 24, 2024 at 5:57 AM Gurjeet Singh <gurjeet@singh.im> wrote:
Is there a desire to have a division operator / that takes dividend
and divisor of types interval, and results in a quotient of type
double precision.

This would be helpful in calculating how many times the divisor
interval can fit into the dividend interval.

To complement this division operator, it would be desirable to also
have a remainder operator %.

For example,

('365 days'::interval / '5 days'::interval) => 73
('365 days'::interval % '5 days'::interval) => 0

('365 days'::interval / '3 days'::interval) => 121
('365 days'::interval % '3 days'::interval) => 2

Best regards,
Gurjeet
http://Gurje.et


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

Предыдущее
От: Yugo NAGATA
Дата:
Сообщение: Re: Avoid incomplete copy string (src/backend/access/transam/xlog.c)
Следующее
От: Alexander Lakhin
Дата:
Сообщение: Buildfarm animal caiman showing a plperl test issue with newer Perl versions