From: Noah Misch <noah@leadboat.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Chapman Flack <chap@anastigmatix.net>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: Joe Nelson <joe@begriffs.com>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: Re: POC: rational number type (fractions)
Date: Thu, 21 May 2020 22:53:32 -0700
Message-ID: <20200522055332.GA1296415@rfd.leadboat.com> (raw)
In-Reply-To: <CA+TgmobheOusVXxzKX6y3NaHYdTuoRFEaff6DcYMOEBgjY8gBQ@mail.gmail.com>
References: <20200208042554.GE42864@begriffs.com>
<0e2422da-953b-6b96-1900-f67c7e5e3307@2ndquadrant.com>
<5EC3031C.6020105@anastigmatix.net>
<20552.1589840076@sss.pgh.pa.us>
<CA+TgmobheOusVXxzKX6y3NaHYdTuoRFEaff6DcYMOEBgjY8gBQ@mail.gmail.com>
On Thu, May 21, 2020 at 01:40:10PM -0400, Robert Haas wrote:
> On Mon, May 18, 2020 at 6:15 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > There surely are use-cases for true rational arithmetic, but I'm
> > dubious that it belongs in core Postgres. I don't think that enough
> > of our users would want it to justify expending core-project maintenance
> > effort on it. So I'd be happier to see this as an out-of-core extension.
>
> As is often the case, I'm a little more positive about including this
> than Tom, but as is also often the case, I'm somewhat cautious, too.
> On the one hand, I think it would be cool to have and people would
> like it. But, On the other hand, I also think we'd only want it if
> we're convinced that it's a really good implementation and that
> there's not a competing design which is better, or even equally good.
I vote for keeping it out of core, mostly because writing rational numeric
code is so different from writing DBMS core code. (Many of our existing
types, like numeric and the geometric types, have the same problem. Let's not
invite more of that.) The optimal reviewer pools won't have much overlap, so
patches may sit awhile and/or settle for a cursory review.
More language standard libraries provide "numeric"-style big decimals[1] than
provide big rationals[2], suggesting we're in good company.
[1] https://en.wikipedia.org/wiki/List_of_arbitrary-precision_arithmetic_software#Languages
[2] https://en.wikipedia.org/wiki/Rational_data_type#Language_support
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: noah@leadboat.com, robertmhaas@gmail.com, tgl@sss.pgh.pa.us, chap@anastigmatix.net, peter.eisentraut@2ndquadrant.com, joe@begriffs.com
Subject: Re: POC: rational number type (fractions)
In-Reply-To: <20200522055332.GA1296415@rfd.leadboat.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox