Consider using numeric type. Like BCD, it will perform exact decimal arithmetic.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend