Re: Proposal: SELECT * EXCLUDE (...) command - Mailing list pgsql-hackers

From Marcos Pegoraro
Subject Re: Proposal: SELECT * EXCLUDE (...) command
Date
Msg-id CAB-JLwaQgRmGEx4WMu-GgnXgLSBQX+S-yWCKw2+dE3MvoMvgWg@mail.gmail.com
Whole thread
In response to Re: Proposal: SELECT * EXCLUDE (...) command  (Hunaid Sohail <hunaidpgml@gmail.com>)
List pgsql-hackers
Em sex., 9 de out. de 2026 às 11:13, Hunaid Sohail <hunaidpgml@gmail.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

pgsql-hackers by date:

Previous
From: Álvaro Herrera
Date:
Subject: Re: Bug in logical decoding with DDL and subtransactions
Next
From: Tom Lane
Date:
Subject: Re: Wrong results from a parameterized Append