Thread

1. decimal(x,y) function.

   Jonah Kuo <jonahkuo@mail.ttn.com.tw> — 1998-05-25T08:56:09Z

   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
   
   
   
   

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

   Jonah Kuo <jonahkuo@mail.ttn.com.tw> — 1998-05-25T10:01:39Z

   
   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?
   
   
   
   

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

   jose' soares <sferac@bo.nettuno.it> — 1998-05-25T11:14:04Z

   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'