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

On Nov 1, 2011, at 6:47 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> I can think of a number of places where you can write "*" where I'm
> pretty sure we *don't* want this.  It should be restricted to top-level
> entries in SELECT targetlists, IMO.

Yes. That is the exact conclusion I've come to.  

However, why is
   select table.* foo from table 

allowed?  What does that even mean?

eric