Received: from ms1.ttn.com.tw (ms1.ttn.com.tw [203.66.150.3]) by hub.org (8.8.8/8.7.5) with ESMTP id FAA24550 for ; Mon, 25 May 1998 05:56:44 -0400 (EDT) Received: from mail.ttn.com.tw (cs1p02.txg.ttn.net.tw [210.17.80.98]) by ms1.ttn.com.tw (8.8.5/8.8.8) with ESMTP id RAA00276; Mon, 25 May 1998 17:51:25 +0800 (CST) Message-ID: <35694183.444DC5C9@mail.ttn.com.tw> Date: Mon, 25 May 1998 18:01:39 +0800 From: Jonah Kuo Reply-To: jonahkuo@mail.ttn.com.tw X-Mailer: Mozilla 4.04 [en] (Win95; I) MIME-Version: 1.0 To: "Jose' Soares Da Silva" CC: pgsqsl-sql Subject: Re: [SQL] decimal(x,y) function. References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Jose' Soares Da Silva wrote: > 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' How can I change a column's type defined decimal(8,0) to money?