Postgres Pro
Downloads
Home   >   mailing lists

Re: A modest proposal vis hierarchical queries: MINUS in the column list - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: A modest proposal vis hierarchical queries: MINUS in the column list
Date
Msg-id CAKFQuwaBgtt7M4VWbDfjmLdJfH5TmM5T+qt5Od49LhTx=+qjyw@mail.gmail.com
Whole thread Raw
In response to A modest proposal vis hierarchical queries: MINUS in the column list  (Mark Zellers <mark.zellers@workday.com>)
Responses Re: A modest proposal vis hierarchical queries: MINUS in the column list
List pgsql-hackers
Tree view
On Mon, Jun 7, 2021 at 1:54 PM Mark Zellers <mark.zellers@workday.com> wrote:

Failing that, I have a modest suggestion that I would like to start a discussion around.  What if you could use the MINUS keyword in the column list of a select statement to remove a column from the result set returned to the client?  


I asked this a decade ago and got no useful responses.

https://www.postgresql.org/message-id/flat/02e901cc2bb4%2476bc2090%24643461b0%24%40yahoo.com#3784fab26b0f946b3239266e3b70a6ce

I will say I've still had the itch to want it occasionally in the years since, though not frequently.

David J.

pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: security_definer_search_path GUC
Next
From: Tom Lane
Date:
Subject: Re: Add PortalDrop in exec_execute_message