Обсуждение: decimal(x,y) function.
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
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'
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?