Re: Native type for storing fractions (e.g 1/3)? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Native type for storing fractions (e.g 1/3)?
Date
Msg-id 20070315202613.GB9067@svana.org
Whole thread Raw
In response to Re: Native type for storing fractions (e.g 1/3)?  ("Florian G. Pflug" <fgp@phlo.org>)
Responses Re: Native type for storing fractions (e.g 1/3)?  ("Florian G. Pflug" <fgp@phlo.org>)
List pgsql-general
On Thu, Mar 15, 2007 at 09:11:23PM +0100, Florian G. Pflug wrote:
> You'd need a type for large integers first - otherwise your
> ty_fraction will be quite limited. I think numeric could be
> used for that, though I don't know if numeric guarantees that
> at least the operators +,-,* and modulo return exact results
> (Don't loose digits). But even if they do, using some existing
> library for arbitrary sized integers would probably lead to
> better performance.

Numeric is an arbitrary sized number library, so using that would be
smart.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: [SQL] PostgreSQL to Oracle
Next
From: "Webb Sprague"
Date:
Subject: Re: simple coordinate system