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