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

From Scott Ribe
Subject Re: Real type with zero
Date
Msg-id F817EC5F-3A19-474A-82D9-E45BAB2B41C9@elevated-dev.com
Whole thread Raw
In response to Re: Real type with zero  ("David Johnston" <polobo@yahoo.com>)
List pgsql-general
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 if you really need to maintain info about the significant digits of measurements, you need that to carry
throughproperly in calculations with those numbers. 

OTOH, it's possible to have that info in a separate field, and leave with clients the responsibility for correct
calculations...

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice





pgsql-general by date:

Previous
From: Grace Batumbya
Date:
Subject: Windows x64 : How do I get OSSP-UUID.sql contrib for postgresql x64
Next
From: "Jonathan S. Katz"
Date:
Subject: Re: point types in "DISTINCT" queries