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

From Florian G. Pflug
Subject Re: Native type for storing fractions (e.g 1/3)?
Date
Msg-id 45F9A86B.30509@phlo.org
Whole thread Raw
In response to Re: Native type for storing fractions (e.g 1/3)?  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: Native type for storing fractions (e.g 1/3)?  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Ron Johnson wrote:
> CREATE TYPE ty_fraction AS
> (
>     n        SMALLINT,
>     d           SMALLINT
> );

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.

greetings, Florian Pflug

pgsql-general by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Re: PITR and WAL archiving
Next
From: "Florian G. Pflug"
Date:
Subject: Re: Problem to install pgAdmin