Обсуждение: decimal(9.2)

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

Herbie

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti                            E-Mail: Herbert.Liechti@thinx.ch
ThinX networked business services               Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Try:

dbhpw=> create table therbert (num numeric(9,2));

H.P.

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
>
> Herbie
>
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Herbert Liechti                            E-Mail: Herbert.Liechti@thinx.ch
> ThinX networked business services               Stahlrain 10, CH-5200 Brugg
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----------------------------------
E-Mail: Hans Peter Würmli <wurmli@datacomm.ch>
Date: 25-Jun-99
Time: 20:36:00

This message was sent by XFMail
----------------------------------

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: Herbert.Liechti@thinx.ch
ThinX networked business services               Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Sorry, yes you need 6.5 for the general numeric type.

H.P.

On 25-Jun-99 Herbert Liechti wrote:
> 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?
>