Thread: Column type definition

Column type definition

From
sauerhn
Date:
Hi,

I'd like to store in a table column of type numeric values like 1.0 and
also  values like 1 . For our purpose there is a big difference between
the two values.
Currently  I  use  a float8 column definition type to store very small
values as well as very large values.
Is there any way to accomplish this in postgres except using the
character column type.

In Oracle I used a number column to achieve this.

Thanks in advance.

Regards,

Heidrun