pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feeddecimal(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>
1998-05-25 11:14 ` Re: [SQL] decimal(x,y) function. Jose' Soares Da Silva <sferac@bo.nettuno.it>
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 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 ` Re: [SQL] decimal(x,y) function. 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
* Re: [SQL] decimal(x,y) function.
1998-05-25 08:56 decimal(x,y) function. Jonah Kuo <jonahkuo@mail.ttn.com.tw>
1998-05-25 11:14 ` Re: [SQL] decimal(x,y) function. Jose' Soares Da Silva <sferac@bo.nettuno.it>
@ 1998-05-25 10:01 ` Jonah Kuo <jonahkuo@mail.ttn.com.tw>
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
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