Re: [GENERAL] BCD format

2004-12-29 Thread Christopher Browne
[EMAIL PROTECTED] 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

Re: [GENERAL] BCD format

2004-12-29 Thread Dann Corbit
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

Re: [GENERAL] BCD format

2004-12-29 Thread Joshua D. Drake
[EMAIL PROTECTED] 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 T