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
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 oth
What version of PostgreSQL? Version 6.5 is needed for complete decimal and
number support.
> -Original Message-
> From: Herbert Liechti [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, June 25, 1999 10:59 AM
> To: postgres
> Subject: [GENERAL] decimal(9.2)
>
> Hello
>
> How do I defin
Try:
dbhpw=> create table therbert (num numeric(9,2));
H.P.
On 25-Jun-99 Herbert Liechti wrote:
> Hello
>
> How do I define the datatype decimal(9.2). I searched the documentation
> but the only thing I found was the money data type which is in my case
> not very usefull.
>
> Is there a way t
