| From: | Radoslaw Smogura <rsmogura(at)softperience(dot)eu> |
|---|---|
| To: | <condor(at)stz-bg(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Real type with zero |
| Date: | 2011-06-29 12:40:35 |
| Message-ID: | 20110629124039.A72A6B5DBD5@mail.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2011-06-29 13:50:23 | Re: Real type with zero |
| Previous Message | Emrul Islam | 2011-06-29 11:53:52 | Re: Multi-tenancy in Postgres |