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