Can you explain what you mean by "put it in a domain" - I'd love extra style points, but this sounds like a feature I haven't learned about yet. On Fri, Oct 9, 2009 at 3:38 AM, Peter Eisentraut <peter_e@xxxxxxx> wrote: > 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
