Re: [SQL] decimal(x,y) function. - Mailing list pgsql-sql

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'