Re: Sort question - Fractions, Metric etc - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Sort question - Fractions, Metric etc
Date
Msg-id bc0b146e-5050-34fc-94a0-9775f736c0ec@aklaver.com
Whole thread Raw
In response to Re: Sort question - Fractions, Metric etc  (Sándor Daku <daku.sandor@gmail.com>)
List pgsql-general
On 8/14/21 10:19 AM, Sándor Daku wrote:
> 

> I'm not sure, but maybe a kind of cast function that cast everything 
> into a reasonable common unit(Khm... millimeters) and sort on that? It 
> seems relatively simple to pick up the value and unit from a string with 
> a regexp. Admittedly the data would still be a mess.

I see the potential for another crash landing:) :

https://en.wikipedia.org/wiki/Mars_Climate_Orbiter#Cause_of_failure


> 
> Regards,
> Sándor


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Sándor Daku
Date:
Subject: Re: Sort question - Fractions, Metric etc
Next
From: "bret_stern@machinemanagement.com"
Date:
Subject: Re: Sort question - Fractions, Metric etc