Re: Numbers
От | Bob Pawley |
---|---|
Тема | Re: Numbers |
Дата | |
Msg-id | 014501c61fa5$dff61870$ac1d4318@owner обсуждение исходный текст |
Ответ на | Numbers (Bob Pawley <rjpawley@shaw.ca>) |
Ответы |
Re: Numbers
Re: Numbers |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: