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'