Re: Reducing data type space usage

From: mark(at)mark(dot)mielke(dot)cc
To: Mark Dilger <pgsql(at)markdilger(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, Gregory Stark <stark(at)enterprisedb(dot)com>
Subject: Re: Reducing data type space usage
Date: 2006-09-16 21:31:15
Message-ID: 20060916213114.GA25175@mark.mielke.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Sep 16, 2006 at 02:13:49PM -0700, Mark Dilger wrote:
> Mark Dilger wrote:
> >Wouldn't a 4-byte numeric be a "float4" and an 8-byte numeric be a
> >"float8". I'm not sure I see the difference.
> Nevermind. I don't normally think about numeric as anything other than
> an arbitrarily large floating point type. But it does differ in that
> you can specify the range you want it to cover.

Range and the base, both being important.

Cheers,
mark

--
mark(at)mielke(dot)cc / markm(at)ncf(dot)ca / markm(at)nortel(dot)com __________________________
. . _ ._ . . .__ . . ._. .__ . . . .__ | Neighbourhood Coder
|\/| |_| |_| |/ |_ |\/| | |_ | |/ |_ |
| | | | | \ | \ |__ . | | .|. |__ |__ | \ |__ | Ottawa, Ontario, Canada

One ring to rule them all, one ring to find them, one ring to bring them all
and in the darkness bind them...

http://mark.mielke.cc/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Theo Schlossnagle 2006-09-16 21:37:41 Re: New version of money type
Previous Message Jim C. Nasby 2006-09-16 21:27:55 Re: New version of money type