Tom Lane writes:
>Andrew Dunstan writes:
>> On 6/7/21 6:10 PM, Tom Lane wrote:
>>> Note that it's not like SQL hasn't heard of projections before.
>>> You can always do "SELECT a, b, d FROM subquery-yielding-a-b-c-d".
>>> So the proposed syntax would save a small amount of typing, but
>>> it's not
On 08.06.21 04:50, Julien Rouhaud wrote:
On Mon, Jun 07, 2021 at 06:10:58PM -0400, Tom Lane wrote:
I'm fairly disinclined to do anything about it though, because I'm
afraid of the SQL committee standardizing some other syntax for the
same idea in future (or maybe worse, commandeering the same k
Andrew Dunstan writes:
> On 6/7/21 6:10 PM, Tom Lane wrote:
>> Note that it's not like SQL hasn't heard of projections before.
>> You can always do "SELECT a, b, d FROM subquery-yielding-a-b-c-d".
>> So the proposed syntax would save a small amount of typing, but
>> it's not adding any real new fu
On 6/7/21 6:10 PM, Tom Lane wrote:
> "David G. Johnston" writes:
>> On Mon, Jun 7, 2021 at 1:54 PM Mark Zellers
>> wrote:
>>> 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
On Mon, Jun 07, 2021 at 06:10:58PM -0400, Tom Lane wrote:
>
> I'm fairly disinclined to do anything about it though, because I'm
> afraid of the SQL committee standardizing some other syntax for the
> same idea in future (or maybe worse, commandeering the same keyword
> for some other feature). I
"David G. Johnston" writes:
> On Mon, Jun 7, 2021 at 1:54 PM Mark Zellers
> wrote:
>> 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.
> h
On Mon, Jun 7, 2021 at 1:54 PM Mark Zellers
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
