Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?

On Sun, Oct 30, 2011 at 2:15 PM, Jim Nasby <jim@nasby.net> wrote:
> If you know that you want all fields except X, Y and Z, why should you be forced to manually cut and paste all the
otherfields into the view definition? That's wasted time and effort that could better be spent elsewhere.
 

I agree.  This isn't something I would recommend that people do in the
queries they embed in their application, but for ad-hoc queries it
comes up all the time.

OTOH, I'm slightly afraid of how much work it would take to implement
this properly.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company