Re: numeric definition advice - Mailing list pgsql-novice

On 07/03/2008, at 14:37, Tom Lane wrote:

> 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.

thanks ...


raimon