Re: numeric definition advice - Mailing list pgsql-novice

Raimon Fernandez <coder@montx.com> writes:
> Is valid to have a numeric with no precision and a scale of 2 ?

No.  You can do something like NUMERIC(1000,2) though.  It's pretty
much like VARCHAR --- the number you give is an upper limit, it's
not causing any wasted space to be allocated.

            regards, tom lane