> On Feb 25, 2020, at 11:28 , Paul A Jungwirth <[email protected]> > wrote: > > On Tue, Feb 25, 2020 at 2:18 AM Stanislav Motyčka > <[email protected] <mailto:[email protected]>> 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.
