decimal(x,y) function.

Jonah Kuo <jonahkuo@mail.ttn.com.tw>

From: Jonah Kuo <jonahkuo@mail.ttn.com.tw>
To: pgsqsl-sql <pgsql-sql@postgresql.org>
Date: 1998-05-25T08:56:09Z
Lists: pgsql-sql
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