Postgres Pro
Downloads
Home   >   mailing lists

float formating with xx.00 - Mailing list pgsql-general

From Mark
Subject float formating with xx.00
Date
Msg-id 0HHG009L2U8C9F@VL-MS-MR002.sc1.videotron.ca
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: problems with pg_restore to 7.3.3 db
Next
From: Richard Huxton
Date:
Subject: Re: Rollback for aborted function?