Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."? - Mailing list pgsql-hackers

From Darren Duncan
Subject Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?
Date
Msg-id 4EADCB95.7060805@darrenduncan.net
Whole thread Raw
In response to Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?  (Eric Ridge <eebbrr@gmail.com>)
Responses Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Eric Ridge wrote:
> I don't actually like the term "EXCLUDING", but it conveys what's
> happening and is already defined as a keyword.  I thought about
> "EXCEPT", but that doesn't work for obvious reasons, and "NOT" might
> just be confusing.

How about "BUT"?

Is that already in use by something?  Its nice and short and conveys the 
"except" meaning.

And there is already precedent for using that word for this purpose.

CJ Date already uses "ALL BUT" in his literature as a modifier to his 
illustrative relation projection syntax to give the complementary projection, 
like with "r{x,y}" vs "r{all but x,y}".

Also, a more tenuous connection, Larry Wall likes "but" as logical modifier.

-- Darren Duncan


pgsql-hackers by date:

Previous
From: Eric Ridge
Date:
Subject: Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?
Next
From: Eric Ridge
Date:
Subject: Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?