> 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.



Reply via email to