Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?
От | Christopher Browne |
---|---|
Тема | Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."? |
Дата | |
Msg-id | CAFNqd5VknLDUeYZBP=_TaRHFfmeE54Xe=WnLXtuMi_VxO_zZSQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."? (Darren Duncan <darren@darrenduncan.net>) |
Ответы |
Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?
Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."? |
Список | 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 по дате отправления: