On Thu, Jun 10, 2021 at 8:40 PM Luca Ferrari <fluca1978@xxxxxxxxx> wrote: > On Thu, Jun 10, 2021 at 10:15 AM Vijaykumar Jain > > when you provide a table in query in the order by clause, it is > > ordered by cols of that table in that order. > > Clever, thanks! > I also realized that this "table to tuples" expansion works for GROUP BY too. > However, I'm not able to find this documented in GROUP BY, WHERE, > ORDER BY clauses sections into select documentation > <fgrouphttps://www.postgresql.org/docs/12/sql-select.html>. Could be > my fault, of course. There's something about this here: https://www.postgresql.org/docs/13/rowtypes.html#ROWTYPES-USAGE
