| From: | Marcos Pegoraro <marcos(at)f10(dot)com(dot)br> |
|---|---|
| To: | Hunaid Sohail <hunaidpgml(at)gmail(dot)com> |
| Cc: | Robert Treat <rob(at)xzilla(dot)net>, Kacper Kuras <kacperkuras(at)hotmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Peter Eisentraut <peter(at)eisentraut(dot)org>, Christoph Berg <myon(at)debian(dot)org> |
| Subject: | Re: Proposal: SELECT * EXCLUDE (...) command |
| Date: | 2026-10-09 19:04:22 |
| Message-ID: | CAB-JLwaQgRmGEx4WMu-GgnXgLSBQX+S-yWCKw2+dE3MvoMvgWg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Em sex., 9 de out. de 2026 às 11:13, Hunaid Sohail <hunaidpgml(at)gmail(dot)com>
escreveu:
> PFA v3 of the patch.
>
I didn't find any test with nested EXCLUDE, would be good to see if works
with fields that were already EXCLUDED and NOT MATERIALIZED to test not
inlined CTEs
SELECT * (EXCLUDE (id, created_at)) FROM (SELECT * (EXCLUDE (id)) FROM
users);
WITH CTE AS NOT MATERIALIZED (SELECT * (EXCLUDE (id, created_at)) FROM
users) SELECT * (EXCLUDE (id)) FROM CTE;
regards
Marcos
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2026-10-09 19:13:06 | Re: Wrong results from a parameterized Append |
| Previous Message | Álvaro Herrera | 2026-10-09 18:11:18 | Re: Bug in logical decoding with DDL and subtransactions |