-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David Johnston
Sent: Wednesday, June 29, 2011 11:51 AM
To: 'Grzegorz Jaśkiewicz'; con...@stz-bg.com
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Real
On Jun 29, 2011, at 9:50 AM, David Johnston wrote:
> Aside from storing the "true" precision in a separate integer field what
> solution is there is this situation.
I think the only other way would be a custom data type encapsulating those 2
bits of info. Which might be the best solution, since
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Grzegorz Jaskiewicz
Sent: Wednesday, June 29, 2011 7:44 AM
To: con...@stz-bg.com
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Real type with zero
what you
On 29/06/2011 7:24 PM, Condor wrote:
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.
The real data type is an IEEE 754 floating point number. See:
http://en.wikipedia.org/wiki/Floating_point
http://st
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@postgresq
what you probably looking for is formatting the output into a string.
Postgresql will store it as 2.3, because that is what 2.30 is anyway.
Its up to you to format it before passing it on to the user/business
logic/whatever.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
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
