Search Postgresql Archives

Re: Real type with zero

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Your question may suggest you are more interested in storing value, as decimal not real, it's more secure to use this way for 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@xxxxxxxxxxxxxx
Subject:  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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux