Hans Peter Würmli wrote:
> Try:
>
> dbhpw=> create table therbert (num numeric(9,2));
Is not working. I got the following error:
db=> create table therbert (num numeric(9,2));
ERROR: NUMERIC scale 2 must be zero
I use PostgreSQL 6.4.0 on i586-pc-linux-gnu, compiled by gcc egcs-2.91.6
Any other hints?
> On 25-Jun-99 Herbert Liechti wrote:
> > Hello
> >
> > How do I define the datatype decimal(9.2). I searched the documentation
> > but the only thing I found was the money data type which is in my case
> > not very usefull.
> >
> > Is there a way to declare a datatype with 2 decimal places and with a fixed
> > precision? Thanks for your help
>
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti E-Mail: [EMAIL PROTECTED]
ThinX networked business services Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
