sort output per alpha-numeric?

From:	Sbob	Date:	Wed, 01 Dec 2021 22:35:59 +0000
Subject:	sort output per alpha-numeric?
Groups:	php.general
Request:	Send a blank email to php-general+get-327847@lists.php.net to get a copy of this message

All; I have a set of tables that looks like this: \d portfolio_sc_images_print_size_asc

       Table "public.portfolio_sc_images_print_size_asc"
        Column         |  Type  | Collation | Nullable | Default

------------------------+--------+-----------+----------+---------

portfolio_sc_images_id | bigint |           | not null |
print_type_id          | bigint |           | not null |
print_size_id          | bigint |           | not null |

Indexes: "portfolio_sc_images_print_size_asc_pkey" PRIMARY KEY, btree (portfolio_sc_images_id, print_type_id, print_size_id) Foreign-key constraints: "portfolio_sc_images_print_size_asc_portfolio_sc_images_id_fkey" FOREIGN KEY (portfolio_sc_images_id) REFERENCES portfolio_ sc_images(portfolio_sc_images_id) "portfolio_sc_images_print_size_asc_print_size_id_fkey" FOREIGN KEY (print_size_id) REFERENCES print_sizes(print_size_id) "portfolio_sc_images_print_size_asc_print_type_id_fkey" FOREIGN KEY (print_type_id) REFERENCES print_types(print_type_id) \d print_sizes

                                            Table "public.print_sizes"
   Column     |          Type          | Collation | Nullable |                      Default
---------------+------------------------+-----------+----------+---------------------------------------------------- 
print_size_id | bigint                 |           | not null | nextval('print_sizes_print_size_id_seq'::regclass)
print_size    | character varying(100) |           |          |

Indexes: "print_sizes_pkey" PRIMARY KEY, btree (print_size_id) Referenced by: TABLE "portfolio_sc_images_print_size_asc" CONSTRAINT "portfolio_sc_images_print_size_asc_print_size_id_fkey" FOREIGN KEY ( print_size_id) REFERENCES print_sizes(print_size_id) \d print_types

                                            Table "public.print_types"
   Column     |          Type          | Collation | Nullable |                      Default
---------------+------------------------+-----------+----------+---------------------------------------------------- 
print_type_id | bigint                 |           | not null | nextval('print_types_print_type_id_seq'::regclass)
print_type    | character varying(100) |           |          |

Indexes: "print_types_pkey" PRIMARY KEY, btree (print_type_id) Referenced by: TABLE "portfolio_sc_images_print_size_asc" CONSTRAINT "portfolio_sc_images_print_size_asc_print_type_id_fkey" FOREIGN KEY ( print_type_id) REFERENCES print_types(print_type_id) TABLE "print_finishes" CONSTRAINT "print_finishes_print_type_id_fkey" FOREIGN KEY (print_type_id) REFERENCES print_types(pr int_type_id) Below are the table contents. When I run this query: select print_size from print_sizes where print_size_id in (select print_size_id from portfolio_sc_images_print_size_asc where portfolio_sc_images_id = 1 and print_type_id = (select print_type_id from print_types where print_type = 'Loose Fine Art Print')) order by print_size asc; I get a list like this: print_size ------------ 11x14 16x20 20x24 24x30 32x40 40x50 8x10 (7 rows) I want the displayed print_size to be ordered by size (8x10, then 11x14, etc) Is there an easy way to do this? Thanks in advance Table contents: select * from portfolio_sc_images_print_size_asc; portfolio_sc_images_id | print_type_id | print_size_id ------------------------+---------------+---------------

                     1 |             1 |             7
                     1 |             1 |            10
                     1 |             1 |            15
                     1 |             1 |            37
                     1 |             1 |            30
                     1 |             2 |             7
                     1 |             2 |            10
                     1 |             2 |            15
                     1 |             2 |            18
                     1 |             2 |            37
                     1 |             2 |            38
                     1 |             2 |            30

\x Expanded display is on. pixdb=> select * from portfolio_sc_images; -[ RECORD 1 ]--------------+---------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------

portfolio_sc_images_id     | 1

portfolio_subcategories_id | 1

image_location             | /Portfolio/Night_Skies/7009
image_name                 | DSC_2989-Hebrews-1-3.jpg
image_display_name         | Image 7009 - Hebrews 1:3
desc_title                 | Rocky Mountain National Park - Sprague Lake - Hebrews 1:3
desc_text                  | Rocky Mountain National Park at Sprague Lake, an amazing calm night, GOD called forth the Milky Way and it was incredible
display_order              | 1
orig_image_name            |
gimp_image_name            |
print_image_name           |
-[ RECORD 2 ]--------------+----------------------------------------------------------------------------------------------------------------------------------------------------

---------------------------

portfolio_sc_images_id     | 2

portfolio_subcategories_id | 1

image_location             | /Portfolio/Night_Skies/7009
image_name                 | DSC_2989.jpg
image_display_name         | Image 7009
desc_title                 | Rocky Mountain National Park - Sprague Lake
desc_text                  | Rocky Mountain National Park at Sprague Lake, an amazing calm night, GOD called forth the Milky Way and it was incredible
display_order              | 2
orig_image_name            |
gimp_image_name            |
print_image_name           |

select * from print_sizes; print_size_id | print_size ---------------+------------