Re: [HACKERS] Numeric type

Поиск
Список
Период
Сортировка
От Thomas G. Lockhart
Тема Re: [HACKERS] Numeric type
Дата
Msg-id 36937DFF.14C5DEA4@alumni.caltech.edu
обсуждение исходный текст
Ответ на Re: [HACKERS] Numeric type  (Bruce Momjian <maillist@candle.pha.pa.us>)
Ответы Re: [HACKERS] Numeric type  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [HACKERS] Numeric type  (jwieck@debis.com (Jan Wieck))
Re: [HACKERS] Numeric type  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: [HACKERS] Numeric type  (Oleg Bartunov <oleg@sai.msu.su>)
Список pgsql-hackers
> > 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...
                  - Tom


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Thomas G. Lockhart"
Дата:
Сообщение: Re: [DOCS] Postgresql INSTALL-file & Windows
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Numeric type