From: | "Florian G(dot) Pflug" <fgp(at)phlo(dot)org> |
---|---|
To: | "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Native type for storing fractions (e.g 1/3)? |
Date: | 2007-03-15 21:11:28 |
Message-ID: | 45F9B680.6040209@phlo.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Martijn van Oosterhout wrote:
> 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.
Yeah, but it can do much more than just arbitrary sizes integers -
so I figured a library doing just integers might do them faster then
the numeric support in postgres does, or more space-efficient, or
whatever...
It would only make sense to use a different library if it provides
a substantial advantage in speed or space, of course.
greetings, Florian Pflug
From | Date | Subject | |
---|---|---|---|
Next Message | Florian G. Pflug | 2007-03-15 21:18:01 | Re: CREATE TABLESPACE dynamically |
Previous Message | Bruno Wolff III | 2007-03-15 20:56:18 | Re: SQL Question - Group By and % results per row |