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 through properly 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_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice





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

Reply via email to