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
----------------------------------
