Postgres Pro
Downloads
Home   >   mailing lists

Thread: BCD format

BCD format

From
stefari@tiscali.it
Date:
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???

Thanks and happy new year to all !!!

__________________________________________________________________
Tiscali Adsl 2 Mega Free: l'adsl piu' veloce e' gratis!
Naviga libero dai costi fissi con Tiscali Adsl 2 Mega Free, l'adsl Free
piu' veloce in Italia. In piu', se ti abboni entro il 7 gennaio 2005,
navighi gratis fino al 31 marzo. E il costo di adesione e' GRATIS.
http://abbonati.tiscali.it/adsl/

Re: BCD format

From
"Joshua D. Drake"
Date:
stefari@tiscali.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???
>
>
I do not believe PostgreSQL supports BCD by default. However
you could created your own type.

Sincerely,

Joshua D. Drake


>Thanks and happy new year to all !!!
>
>__________________________________________________________________
>Tiscali Adsl 2 Mega Free: l'adsl piu' veloce e' gratis!
>Naviga libero dai costi fissi con Tiscali Adsl 2 Mega Free, l'adsl Free
>piu' veloce in Italia. In piu', se ti abboni entro il 7 gennaio 2005,
>navighi gratis fino al 31 marzo. E il costo di adesione e' GRATIS.
>http://abbonati.tiscali.it/adsl/
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings
>
>


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
Attachment

Re: BCD format

From
"Dann Corbit"
Date:
Consider using numeric type.
Like BCD, it will perform exact decimal arithmetic.

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of
stefari@tiscali.it
Sent: Wednesday, December 29, 2004 7:32 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] BCD format

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???

Thanks and happy new year to all !!!

__________________________________________________________________
Tiscali Adsl 2 Mega Free: l'adsl piu' veloce e' gratis!
Naviga libero dai costi fissi con Tiscali Adsl 2 Mega Free, l'adsl Free
piu' veloce in Italia. In piu', se ti abboni entro il 7 gennaio 2005,
navighi gratis fino al 31 marzo. E il costo di adesione e' GRATIS.
http://abbonati.tiscali.it/adsl/




---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Re: BCD format

From
Christopher Browne
Date:
stefari@tiscali.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"