Re: sort output per alpha-numeric? - Mailing list pgsql-admin

From Rui DeSousa
Subject Re: sort output per alpha-numeric?
Date
Msg-id E3F7F091-808A-4C9E-950D-99B12AFE11D3@crazybean.net
Whole thread Raw
In response to Re: sort output per alpha-numeric?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin


On Dec 1, 2021, at 6:24 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:

 the normalized version of this model would store the width and height measurements separately and your print_size text would be a presentation issue.

I second this approach as it should be normalized into two fields. It would then be a simple order by area.

i.e.   order by width * height 

This would work in the meantime, given the data format doesn’t change:

order by split_part(print_size, 'x', 1)::int * split_part(print_size, 'x', 2)::int

pgsql-admin by date:

Previous
From: Alexey M Boltenkov
Date:
Subject: Re: sort output per alpha-numeric?
Next
From: Jiankang Ji
Date:
Subject: Re: Are you working on both pentaho and postgresql?