Received: from proxy.bazzanese.com (sferac@ip250.tol11.interbusiness.it [195.120.106.250]) by hub.org (8.8.8/8.7.5) with ESMTP id FAA19601 for ; Mon, 25 May 1998 05:22:06 -0400 (EDT) Received: from localhost (sferac@localhost) by proxy.bazzanese.com (8.8.8/8.8.8/Debian/GNU) with SMTP id LAA00790; Mon, 25 May 1998 11:14:04 GMT Date: Mon, 25 May 1998 11:14:04 +0000 (UTC) From: "Jose' Soares Da Silva" X-Sender: sferac@proxy.bazzanese.com To: Jonah Kuo cc: pgsqsl-sql Subject: Re: [SQL] decimal(x,y) function. In-Reply-To: <35693229.450F7394@mail.ttn.com.tw> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Mon, 25 May 1998, Jonah Kuo wrote: > Hello, > > How should I use the decimal(x,y) function? > > I tried use it with the following result: > > db6000=> create table atest ( > db6000-> price decimal(8,2)); > ERROR: DECIMAL scale 2 must be zero > PostgreSQL doesn't yet implement full syntax of SQL DECIMAL type. It accepts only scale equal to 0 as in: DECIMAL(8,0) And it must be DECIMAL, PostgreSQL doesn't recognize the abbreviation DEC Jose'