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

From Bret Stern
Subject Sort question - Fractions, Metric etc
Date
Msg-id 57f60e61-114f-c403-b2e2-820e76f08d64@machinemanagement.com
Whole thread Raw
Responses Re: Sort question - Fractions, Metric etc
Re: Sort question - Fractions, Metric etc
Re: Sort question - Fractions, Metric etc
List pgsql-general
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)

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




pgsql-general by date:

Previous
From: Brent Wood
Date:
Subject: RE: Multi-master replication
Next
From: Adrian Klaver
Date:
Subject: Re: Sort question - Fractions, Metric etc