Hi Tom
I found a datatype called 'interval' which seems to separate time from its
unit.
Is that what you were thinking of??
Bob
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Postgresql" <pgsql-general@postgresql.org>
Sent: Sunday, January 22, 2006 11:25 AM
Subject: Re: [GENERAL] Numbers
> Bob Pawley <rjpawley@shaw.ca> writes:
>> My initial tables have columns containing values such as 12 feet.
>
>> I want to perform calculations.
>
>> Is there a method in Postgresql to separate the 12 from the unit feet or
>> am I forced to make two columns to separate the feet from the 12?
>
> Are you storing '12 feet' as a string? That seems awfully unstructured
> for data that you'd like to do calculations on.
>
> I seem to recall that someone had come up with a datatype that would
> store numbers with units attached, which seems like what you want here.
> Check the PG list archives, and/or poke around on pgfoundry and gborg.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match