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

From: Gurjeet Singh <gurjeet(at)singh(dot)im>
To: Postgres Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Proposal: Division operator for (interval / interval => double precision)
Date: 2024-06-24 00:57:00
Message-ID: CABwTF4W7x=q7tPrhPa6cjZwstDk2d3oYnTQydoc6=YvCTZzY_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2024-06-24 00:58:16 Re: Parallel CREATE INDEX for GIN indexes
Previous Message Michael Paquier 2024-06-24 00:53:52 Re: Avoid incomplete copy string (src/backend/access/transam/xlog.c)