Re: Clarification on the column order of UNION, INTERSECT, and EXCEPT

On Thu, Jul 24, 2025, 09:22 PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/17/queries-union.html > Description: > > When combining queries with UNION, INTERSECT, or EXCEPT, columns are > matched > in the

Clarification on the column order of UNION, INTERSECT, and EXCEPT

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/queries-union.html Description: When combining queries with UNION, INTERSECT, or EXCEPT, columns are matched in the order in which they occur, and not by column name. This can be unexpecte