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

From Tom Lane
Subject Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?
Date
Msg-id 19407.1320205627@sss.pgh.pa.us
Whole thread Raw
In response to Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?  ("Eric B. Ridge" <eebbrr@gmail.com>)
Responses Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?
List pgsql-hackers
"Eric B. Ridge" <eebbrr@gmail.com> writes:
> However, why is
>     select table.* foo from table 
> allowed?  What does that even mean?

Doesn't mean anything, I think --- the SQL standard seems to exclude it.
It's fairly hard to prevent it at the grammar level, since we regard
"foo.*" as a type of primitive expression, but I suspect it might be a
good idea for transformTargetList to throw an error instead of silently
ignoring the column label.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Chris Redekop
Date:
Subject: Re: Hot Backup with rsync fails at pg_clog if under load
Next
From: "David E. Wheeler"
Date:
Subject: Re: removing =>(text, text) in 9.2