On Fri, 2009-10-09 at 00:10 -0700, Mike Christensen wrote: > Wouldn't (4,3) let me store 0.000 through 9.999? Maybe I'm still not > following what both numbers mean. Yes. If you want 0.000 through 0.999, use numeric(3,3). Adding a check constraint might increase clarity. And put it in a domain for extra style points. :-) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general