Column type definition

From: sauerhn <heidrun(dot)sauerdanzwith(at)eml-r(dot)villa-bosch(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: Column type definition
Date: 2010-08-04 11:56:16
Message-ID: 4C595560.2020802@eml-r.villa-bosch.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Browse pgsql-novice by date

  From Date Subject
Next Message LaboRecherche 2010-08-04 16:19:15 Looking for SKYLINE command
Previous Message Lonni J Friedman 2010-08-03 21:42:00 Re: no unique constraint matching given keys for referenced table