|
On 12/02/21 02:55, David G. Johnston
wrote:
On 2 Dec 2021, at 9:50, David G.
Johnston wrote:
On Wed, Dec 1, 2021 at 3:38 PM Sbob
<sbob@xxxxxxxxxxxxxxxxxxxxx>
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).
Natural sort may be less invasive.
order by length(print_size),
print_size
|
