On Sun, Jan 22, 2006 at 02:25:33PM -0500, Tom Lane wrote:
> 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.
Hmm, I only just notic
ot; <[EMAIL PROTECTED]>
> To: "Bob Pawley" <[EMAIL PROTECTED]>
> Cc: "Postgresql"
> Sent: Sunday, January 22, 2006 11:25 AM
> Subject: Re: [GENERAL] Numbers
>
> > Bob Pawley <[EMAIL PROTECTED]> writes:
> >> My initial tables ha
On Sun, Jan 22, 2006 at 02:47:51PM -0800, Bob Pawley wrote:
> I found a datatype called 'interval' which seems to separate time from its
> unit.
>
> Is that what you were thinking of??
I think Tom might be referring to Martijn van Oosterhout's tagged
types:
http://archives.postgresql.org/pgsql-
resql"
Sent: Sunday, January 22, 2006 11:25 AM
Subject: Re: [GENERAL] Numbers
Bob Pawley <[EMAIL PROTECTED]> 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 un
Bob Pawley <[EMAIL PROTECTED]> 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 stor
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?
Bob Pawley