Re: sort output per alpha-numeric?

On 12/02/21 02:55, David G. Johnston wrote:
> On Wed, Dec 1, 2021 at 4:35 PM Gavan Schneider
> <list(dot)pg(dot)gavan(at)pendari(dot)org <mailto:list(dot)pg(dot)gavan(at)pendari(dot)org>> wrote:
>
> On 2 Dec 2021, at 9:50, David G. Johnston wrote:
>
> On Wed, Dec 1, 2021 at 3:38 PM Sbob
> <sbob(at)quadratum-braccas(dot)com
> <mailto:sbob(at)quadratum-braccas(dot)com>> wrote:
>
> I want the displayed print\_size to be ordered by size
> (8x10, then 11x14, etc)
>
> Is there an easy way to do this?
>
> You can sort by an expression. For the data as shown the
> following should
>
>
> A little more heavy handed might be to convert the two numbers
> into a single integer for ranking, e.g.,
>
> Good idea, but "replace(print_size, 'x', '0')::integer" seems like a
> simpler implementation - though I'd want to double-check some
> single-digit scenarios before making a final choice (if there are any
> besides "8" to worry about).
>
> David J.
>
Natural sort may be less invasive.

order by length(print_size), print_size