Re: Sort question - Fractions, Metric etc

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Sándor Daku <daku(dot)sandor(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bret Stern <bret_stern(at)machinemanagement(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Sort question - Fractions, Metric etc
Date: 2021-08-14 17:23:46
Message-ID: bc0b146e-5050-34fc-94a0-9775f736c0ec@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message bret_stern@machinemanagement.com 2021-08-14 17:32:24 Re: Sort question - Fractions, Metric etc
Previous Message Sándor Daku 2021-08-14 17:19:08 Re: Sort question - Fractions, Metric etc