Postgres Pro
Downloads
Home   >   mailing lists

Re: UNION ALL: Apparently based on column order rather than on column name or alias - Mailing list pgsql-general

From Tom Lane
Subject Re: UNION ALL: Apparently based on column order rather than on column name or alias
Date
Msg-id 13386.1544108784@sss.pgh.pa.us
Whole thread Raw
In response to UNION ALL: Apparently based on column order rather than on columnname or alias  (Andreas Schmid <user462411@gmail.com>)
List pgsql-general
Tree view 
Andreas Schmid <user462411@gmail.com> writes:
> So my conclusion is that the result of UNION ALL depends on the column
> order, not on the column names or aliases. Is this the intended
> behaviour?

Yes, this is required by SQL spec.  Matching by column name would
be used if you wrote a CORRESPONDING clause, but we don't implement
that feature.

            regards, tom lane

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: order of reading the conf files
Next
From: Thomas Kellerer
Date:
Subject: Re: order of reading the conf files