> On Feb 25, 2020, at 11:28 , Paul A Jungwirth <p...@illuminatedcomputing.com> > wrote: > > On Tue, Feb 25, 2020 at 2:18 AM Stanislav Motyčka > <stanislav.moty...@gmail.com <mailto:stanislav.moty...@gmail.com>> wrote: >> Sometimes (for tables with many columns) it would be better and easier to >> write "SELECT" statement with clause "EXCEPT": >> "SELECT * [EXCEPT col1 [,col2]] FROM …"
The single biggest benefit is that I could write many more views that don’t need to be changed when I change the underlying table.
