pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
decimal(x,y) function.
3+ messages / 2 participants
[nested] [flat]

* decimal(x,y) function.
@ 1998-05-25 08:56  Jonah Kuo <jonahkuo@mail.ttn.com.tw>
  0 siblings, 1 reply; 3+ messages in thread

From: Jonah Kuo @ 1998-05-25 08:56 UTC (permalink / raw)
  To: pgsql-sql

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





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [SQL] decimal(x,y) function.
@ 1998-05-25 10:01  Jonah Kuo <jonahkuo@mail.ttn.com.tw>
  parent: Jose' Soares Da Silva <sferac@bo.nettuno.it>
  0 siblings, 0 replies; 3+ messages in thread

From: Jonah Kuo @ 1998-05-25 10:01 UTC (permalink / raw)
  To: Jose' Soares Da Silva <sferac@bo.nettuno.it>; +Cc: 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?





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [SQL] decimal(x,y) function.
@ 1998-05-25 11:14  Jose' Soares Da Silva <sferac@bo.nettuno.it>
  parent: Jonah Kuo <jonahkuo@mail.ttn.com.tw>
  0 siblings, 1 reply; 3+ messages in thread

From: Jose' Soares Da Silva @ 1998-05-25 11:14 UTC (permalink / raw)
  To: Jonah Kuo <jonahkuo@mail.ttn.com.tw>; +Cc: 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'




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~1998-05-25 11:14 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-05-25 08:56 decimal(x,y) function. Jonah Kuo <jonahkuo@mail.ttn.com.tw>
1998-05-25 11:14 ` Jose' Soares Da Silva <sferac@bo.nettuno.it>
1998-05-25 10:01   ` Jonah Kuo <jonahkuo@mail.ttn.com.tw>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox