Proposal: Division operator for (interval / interval => double precision) - Mailing list pgsql-hackers

From Gurjeet Singh
Subject Proposal: Division operator for (interval / interval => double precision)
Date
Msg-id CABwTF4W7x=q7tPrhPa6cjZwstDk2d3oYnTQydoc6=YvCTZzY_w@mail.gmail.com
Whole thread Raw
Responses Re: Proposal: Division operator for (interval / interval => double precision)
Re: Proposal: Division operator for (interval / interval => double precision)
Re: Proposal: Division operator for (interval / interval => double precision)
List pgsql-hackers
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 by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Avoid incomplete copy string (src/backend/access/transam/xlog.c)
Next
From: Tomas Vondra
Date:
Subject: Re: Parallel CREATE INDEX for GIN indexes