On Wed, Dec 1, 2021 at 4:35 PM Gavan Schneider <list.pg.gavan@xxxxxxxxxxx> 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).
David J.
