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

From Eric Ridge
Subject Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?
Date
Msg-id CANcm6watg88zZrUMnRYUv_uuUFPmB9toBVg+f=_2GSwGn2_SKQ@mail.gmail.com
Whole thread Raw
In response to Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, Nov 1, 2011 at 11:47 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> 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.

Let me take a stab at fixing it in the grammar... if it's even do-able.

If it can be fixed at the grammar, it'll get me a lot closer to doing
what I want to do with the actual feature.

eric


pgsql-hackers by date:

Previous
From: pasman pasmański
Date:
Subject: Compile file_fdw with Mingw Developer Studio
Next
From: Robert Haas
Date:
Subject: Re: removing =>(text, text) in 9.2