Skip site navigation (1) Skip section navigation (2)

Re: BCD format

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: BCD format
Date: 2004-12-29 22:28:34
Message-ID: m3u0q420z1.fsf@knuth.knuth.cbbrowne.com (view raw or flat)
Thread:
Lists: pgsql-general
stefari(at)tiscali(dot)it wrote:
> Hi all !
> I have to create a table with a BCD formatted field.
> Can Postrgresql to support this field's type or I have to insert it in binary
> mode???

Have you considered using a NUMERIC field instead?  That supports
exact fixed point arithmetic, much like BCD.

And I don't think that C compilers commonly support a BCD type, so if
you emulated it, you'd be left doing quite a lot of work to make a
type that wouldn't be terribly efficient.
-- 
output = reverse("gro.mca" "@" "enworbbc")
http://linuxfinances.info/info/emacs.html
"Popularity is the hallmark of mediocrity."  --Niles Crane, "Frasier"

In response to

pgsql-general by date

Next:From: Tom LaneDate: 2004-12-29 22:28:36
Subject: Re: debug_print_plan (pg7.4) doesn't seem to do anything
Previous:From: Ed L.Date: 2004-12-29 22:25:05
Subject: WARNING: group with ID NNN does not exist

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group