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