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

From Christopher Browne
Subject Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?
Date
Msg-id CAFNqd5VknLDUeYZBP=_TaRHFfmeE54Xe=WnLXtuMi_VxO_zZSQ@mail.gmail.com
Whole thread Raw
In response to Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?  (Darren Duncan <darren@darrenduncan.net>)
Responses Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?
Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?
List pgsql-hackers
<p>There is legitimate reason to reject this on the basis of nondeterminism.<p>While we are surely obliged to "hold our
noses"and support "SELECT *", as:<br /> A) The SQL standard obliges us, and<br /> B) People already use it a
lot,<p>Neitherof those factors hold true for the EXCLUDING notion.  So all things are decidedly not equal.<p>By all
meansI find it an interesting feature, but that shouldn't be mistaken for necessarily being a desirable feature. <p> I
don'tthink I wish it.  We're telling our developers not to use "select *", and I don't think having "select * except "
wouldchange that policy, beyond requiring us to waste time explaining :<p>"No, we're not changing policy.  The fact
thatPGDG added this to 9.2 does *not* imply our policy was wrong." 

pgsql-hackers by date:

Previous
From: "Eric B. Ridge"
Date:
Subject: Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?
Next
From: Tom Lane
Date:
Subject: Re: myProcLocks initialization