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 EAA15998 for ; Mon, 25 May 1998 04:52:14 -0400 (EDT) Received: from mail.ttn.com.tw (cs1p15.txg.ttn.net.tw [210.17.80.111]) by ms1.ttn.com.tw (8.8.5/8.8.8) with ESMTP id QAA28026 for ; Mon, 25 May 1998 16:47:27 +0800 (CST) Message-ID: <35693229.450F7394@mail.ttn.com.tw> Date: Mon, 25 May 1998 16:56:09 +0800 From: Jonah Kuo Reply-To: jonahkuo@mail.ttn.com.tw X-Mailer: Mozilla 4.04 [en] (Win95; I) MIME-Version: 1.0 To: pgsqsl-sql Subject: decimal(x,y) function. Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 thanks in advance, Jonah