Re: [HACKERS] Numeric field quirk [Again]

2000-10-09 Thread Bruce Momjian
> Greetings, > > Well, it seems that the numeric issue I was having has nothing to do with > the precision and scale being set the same, it has to do with the input > data. The precision has to be at least 2 greater than the biggest number > you need to enter, i.e. > > equinox=# create table

Re: [HACKERS] Numeric field quirk [Again]

2000-10-05 Thread Jan Wieck
Matthew Hagerty wrote: > Greetings, > > Well, it seems that the numeric issue I was having has nothing to do with > the precision and scale being set the same, it has to do with the input > data. The precision has to be at least 2 greater than the biggest number > you need to enter, i.e. > > equi

Re: [HACKERS] Numeric field quirk [Again]

2000-10-04 Thread Tom Lane
Matthew Hagerty <[EMAIL PROTECTED]> writes: > Well, it seems that the numeric issue I was having has nothing to do with > the precision and scale being set the same, it has to do with the input > data. The precision has to be at least 2 greater than the biggest number > you need to enter, i.e.

[HACKERS] Numeric field quirk [Again]

2000-10-04 Thread Matthew Hagerty
Greetings, Well, it seems that the numeric issue I was having has nothing to do with the precision and scale being set the same, it has to do with the input data. The precision has to be at least 2 greater than the biggest number you need to enter, i.e. equinox=# create table test ( d numeri

[HACKERS] Numeric field quirk

2000-10-04 Thread Matthew Hagerty
Greetings, I'm not sure if this is a bug, but I thought someone might like to know about it. If you create a numeric field with the precision and scale set the same, you can't insert anything into the field... pg-7.0.2 on FreeBSD-4.0-Rel. Matthew equinox=# create table test2 ( d numeric(8