Обсуждение: Column type definition

Поиск
Список
Период
Сортировка

Column type definition

От
sauerhn
Дата:
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