Re: Sort question - Fractions, Metric etc

I like that idea

On 8/14/2021 9:46 AM, Adrian Klaver wrote:
> On 8/14/21 9:37 AM, Bret Stern wrote:
>> Strings;
>>
>> I haven't explored doing this with numeric types, but some columns 
>> needed alpha chars eg 13mm.
>
> Two columns:
>
> data_val(numeric)    data_unit(varchar)
> 13            mm
>
>>
>> Although I could have front ended this UI with mm nomenclature I did 
>> not.
>>
>> I'll put a table together with appropriate numeric types and see if 
>> the sort will behave.
>
> It will.
>
>>
>>
>>
>> On 8/14/2021 9:21 AM, Adrian Klaver wrote:
>>> On 8/14/21 9:14 AM, Bret Stern wrote:
>>>> I have a table with metric, imperial, fraction columns.
>>>>
>>>> Is there a way to sort correctly using imperial (eg; .125, .375, 
>>>> .437 -> 1., 1.125)
>>>
>>> Alright how is this different from metric or fraction?
>>>
>>> I can sort of see fraction if you mean as 1/3, 1/20, etc.
>>>
>>> What is the data type of the field you are storing this in?
>>>
>>>>
>>>> Couldn't handle it with ORDER BY ASC, DESC args so I added a 
>>>> sort_column and sorted based
>>>>
>>>> on those values eg; 1,2,3,4,5,6 indicating the value I need to show 
>>>> in which sequence.
>>>>
>>>>
>>>> Just curious what the pro's do
>>>>
>>>> Bret
>>>>
>>>>
>>>>
>>>
>>>
>
>