Postgres Pro
Downloads
Home   >   mailing lists

Re: POC: rational number type (fractions) - Mailing list pgsql-hackers

From Chapman Flack
Subject Re: POC: rational number type (fractions)
Date
Msg-id 5EC3031C.6020105@anastigmatix.net
Whole thread Raw
In response to Re: POC: rational number type (fractions)  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: POC: rational number type (fractions)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
On 05/18/20 17:33, Peter Eisentraut wrote:
> The numeric type already stores rational numbers.  How is this different? 
> What's the use?

Seems like numeric is a base-10000 representation. Will work ok for
a rational whose denominator factors into 2s and 5s.

Won't ever quite represent, say, 1/3, no matter how big you let it get.

Regards,
-Chap

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: PostgresSQL project
Next
From: Tom Lane
Date:
Subject: Re: POC: rational number type (fractions)