[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] decimal(9.2)
From:       Hans Peter=?iso-8859-1?Q?_W=FCrmli?= <wurmli () datacomm ! ch>
Date:       1999-06-26 6:19:55
[Download RAW message or body]

Sorry, yes you need 6.5 for the general numeric type.

H.P.

On 25-Jun-99 Herbert Liechti wrote:
> Hans Peter Würmli wrote:
> 
>> Try:
>>
>> dbhpw=> create table therbert (num numeric(9,2));
> 
> Is not working. I got the following error:
> 
> db=> create table therbert (num numeric(9,2));
> ERROR:  NUMERIC scale 2 must be zero
> 
> I use PostgreSQL 6.4.0 on i586-pc-linux-gnu, compiled by gcc egcs-2.91.6
> 
> Any other hints?
> 

[prev in list] [next in list] [prev in thread] [next in thread]