On Thu, Jun 10, 2021 at 10:15 AM Vijaykumar Jain <vijaykumarjain.github@xxxxxxxxx> wrote: > you can run an explain analyze to check what is going on, > 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. Luca
