Thread: decimal(x,y) function.

decimal(x,y) function.

From

Jonah Kuo

Date:

25 May 1998, 07:52:17

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

    thanks in advance,

Jonah

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

From

"Jose' Soares Da Silva"

Date:

25 May 1998, 08:22:08

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'

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

From

Jonah Kuo

Date:

25 May 1998, 08:56:49


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?