Re: numeric definition advice

by tgl@[EMAIL PROTECTED] (Tom Lane) Mar 7, 2008 at 08:37 AM

Raimon Fernandez <coder@[EMAIL PROTECTED]
> 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

-- 
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

12 Posts in Topic:

Explain explained

markus@[EMAIL PROTECTED]

2008-03-04 09:53:32

Re: Explain explained

rdeleonp@[EMAIL PROTECTED

2008-03-04 10:21:07

Re: Explain explained

tgl@[EMAIL PROTECTED] (T

2008-03-04 13:26:17

Re: Explain explained

markus@[EMAIL PROTECTED]