Re: Real type with zero - Mailing list pgsql-general

From Radoslaw Smogura
Subject Re: Real type with zero
Date
Msg-id 20110629124039.A72A6B5DBD5@mail.postgresql.org
Whole thread Raw
In response to Real type with zero  (Condor <condor@stz-bg.com>)
List pgsql-general
Your question may suggest you are more interested in storing value, as decimal not real, it's more secure to use this
wayfor moneys, but even with decimal your trailing zeros may be removed.

Regards,
Radoslaw Smogura 

-----Original Message-----
From: Condor
Sent: 29 czerwca 2011 13:24
To: pgsql-general@postgresql.org
Subject: [GENERAL] Real type with zero

Hello,
how I can tell my postgresql to store last zero of real type ? I put
value 2.30 and when I select that column i see 2.3 without zero.


--
Regards,
Condor

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



pgsql-general by date:

Previous
From: Emrul Islam
Date:
Subject: Re: Multi-tenancy in Postgres
Next
From: Craig Ringer
Date:
Subject: Re: Real type with zero