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

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?