Re: Add example to sort results by two composite types

On Sunday, July 13, 2025, PG Doc comments form <noreply(at)postgresql(dot)org>
wrote:

>
> I suggest to extend the example to sort results by first composite type and
> then by the second:
> SELECT * FROM invertory_type t, inventory_item c ORDER BY (c.name,
> c.supplier_id, c.price), (t.name, t.value);
>
> Though I did not checked this if it possible or not. It would be nice to
> have it documented.
>

What new information does that add or uncertainty does it clarify? This
isn’t a section teaching order by - the reader is expected to already
understand that an order by clause can accept two column names and how
those are treated (i.e., ties among the first are broken by the second).
This is a section about how within that structure the comparisons happen.
A single column suffices to make that explanation.

David J.