| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | trescher40(at)gmx(dot)de |
| Subject: | UNION does not append |
| Date: | 2025-10-07 22:27:14 |
| Message-ID: | 175987603436.768.10549246436481476867@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/18/queries-union.html
Description:
I'm very confused about this statement in the documentation of UNION: "UNION
effectively appends the result of query2 to the result of query1".
Because, if I append one item to a list, it is still the same list. But in
the case of UNION, it's ""copied"" into a new anonymous derived-table. Alias
don't work anymore, which I would expect if I just append some rows. Or is
it like "effectively" means that this statement is not to be taken
literally? In that case I would really appreciate a more detailed
description, that after the UNION with tables a new anonymous derived-table
is returned and the original first table can't be accessed anymore. Thank
you for taking your time to read this even if you disagree.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shinya Kato | 2025-10-08 00:34:19 | Re: doc: Fix missing closing parentheses in monitoring.sgml |
| Previous Message | Dmitry Igrishin | 2025-10-07 16:08:22 | CancelRequest(F) documentation. |