I want the displayed print_size to be ordered by size (8x10, then 11x14, etc)
Is there an easy way to do this?
Sometimes over-sharing is just as bad as under-sharing...consider creating minimalistic examples, usually with the help of a CTE to provide data directly within the query and avoiding the need for tables altogether.
You can sort by an expression. For the data as shown the following should work:
ORDER BY CASE WHEN print_size ~ '^\dx' THEN '0' || print_size ELSE print_size END
In short, the least invasive solution is to just prepend a zero to a single digit size.
If this isn't sufficient (e.g., if the second dimension causes the issue) you may need to break the two-part string into two separate fields, convert them to integers, and then sort on the pair.
You could also create a custom type and define a custom comparison function...
