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

Jose' Soares Da Silva wrote:

> 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'

  How can I change a column's type defined decimal(8,0) to money?