Re: Add operator for dividing interval by an interval

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Add operator for dividing interval by an interval
Date: 2023-05-18 21:03:24
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Andres Freund <andres(at)anarazel(dot)de> writes:
> What about an interval / interval -> double operator that errors out whenever
> month is non-zero? As far as I can tell that would always be deterministic.

We have months, days, and microseconds, and microseconds-per-day isn't
much more stable than days-per-month (because DST). By the time you
restrict this to give deterministic results, I think it won't be
particularly useful.

You could arbitrarily define months as 30 days and days as 24 hours,
which is what some other interval functions do, and then the double
result would be well-defined; but how useful is it really?

regards, tom lane

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Przemysław Sztoch 2023-05-18 21:14:52 Re: [PATCH] Support % wildcard in extension upgrade filenames
Previous Message Bruce Momjian 2023-05-18 20:49:47 PG 16 draft release notes ready