Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Novice > Re: numeric def...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 9 of 12 Topic 3026 of 3322
Post > Topic >>

Re: numeric definition advice

by coder@[EMAIL PROTECTED] (Raimon Fernandez) Mar 7, 2008 at 07:49 PM

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

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

thanks ...


raimon


-- 
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]   2008-03-04 15:52:30 
Re: Explain explained
tgl@[EMAIL PROTECTED] (T  2008-03-04 17:30:31 
Re: Explain explained
markus@[EMAIL PROTECTED]   2008-03-04 17:59:45 
numeric definition advice
coder@[EMAIL PROTECTED]   2008-03-07 11:40:55 
Re: numeric definition advice
tgl@[EMAIL PROTECTED] (T  2008-03-07 08:37:30 
Re: numeric definition advice
coder@[EMAIL PROTECTED]   2008-03-07 19:49:04 
warnings restoring a db
coder@[EMAIL PROTECTED]   2008-04-09 08:59:48 
Re: warnings restoring a db
tgl@[EMAIL PROTECTED] (T  2008-04-09 10:43:53 
Re: warnings restoring a db
coder@[EMAIL PROTECTED]   2008-04-09 16:52:00 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Dec 5 4:36:33 CST 2008.