Re: [HACKERS] Numeric type
От | Oleg Bartunov |
---|---|
Тема | Re: [HACKERS] Numeric type |
Дата | |
Msg-id | Pine.GSO.3.96.SK.990106192549.16645B-100000@ra обсуждение исходный текст |
Ответ на | Re: [HACKERS] Numeric type ("Thomas G. Lockhart" <lockhart@alumni.caltech.edu>) |
Ответы |
Re: [HACKERS] Numeric type
|
Список | pgsql-hackers |
On Wed, 6 Jan 1999, Thomas G. Lockhart wrote: > Date: Wed, 06 Jan 1999 15:15:11 +0000 > From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu> > To: Bruce Momjian <maillist@candle.pha.pa.us> > Cc: jwieck@debis.com, hackers@postgreSQL.org > Subject: Re: [HACKERS] Numeric type > > > > OK, I give up :) How do I use the numeric type? > > Works here. Don't you hate when that happens: > > postgres=> create table n1 (n numeric(10,5), d decimal(10,5)); > CREATE > postgres=> insert into n1 values ('1.23456', '1.23456'); > ERROR: overflow on numeric > ABS(value) >= 10^0 for field with precision 2086 scale 53380 > > *sigh* > > Any hints on where to look? I did a CVSup update, then a "cvs -PdA" on > my development tree, a "make clean install" and an initdb. I did not try > a full clean checkout, but would think that it wouldn't help. > > Anyone else running on Linux/i686/libc5 having success? If so, I'll go > back to working on outer joins... > On my Linux box/i586/libc5, postgresql 6.4.2: test=> create table n1 (n numeric(10,5), d decimal(10,5)); ERROR: NUMERIC precision 10 must be 9 test=> Something weird ! I compiled postgres 6.4.2 after applying Jan's feature patch and configure --enable-locale Oleg > - Tom > _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
В списке pgsql-hackers по дате отправления: