float formating with xx.00

From: Mark <map(at)inter-resa(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: float formating with xx.00
Date: 2003-07-03 20:28:47
Message-ID: 0HHG009L2U8C9F@VL-MS-MR002.sc1.videotron.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I am trying to enter 19.00 in a float field... no error but the data (select)
is showing 19 without the "trailing" zeros... But for format and standard
presentation of money, I need to keep any last zero digit.

How can I do this? I run version 7.1x
Thanks!
--
Mark

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2003-07-03 20:53:22 Re: [pgadmin-support] [GENERAL] pgAdmin III - Call for Translators
Previous Message Richard Huxton 2003-07-03 20:28:33 Re: Rollback for aborted function?