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

From Eric Ridge
Subject Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?
Date
Msg-id CANcm6wYHiP4YMbJcUD=5e4QCG3mwOm2SHja2T0wmWzyCrt4SoA@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 Sun, Oct 30, 2011 at 3:17 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
<snip>

> "fails to not break anything else" category.

From what I've seen watching this list, you're usually right.  :)

It looks like it's perfectly okay to write:   SELECT pg_class.* AS foo FROM pg_class;
(with or without the AS)

I don't know what the above actually means, but it stops SELECT
pg_class.* EXCLUDING(...) dead in its tracks.  So, I'd have to break a
syntax (albeit silly?) that currently works to support this.  :(

eric


pgsql-hackers by date:

Previous
From: Darren Duncan
Date:
Subject: Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?
Next
From: Robert Haas
Date:
Subject: myProcLocks initialization