Re: [SQL] decimal(x,y) function.

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'