On Tue, Feb 25, 2020 at 2:18 AM Stanislav Motyčka<stanislav.motycka@xxxxxxxxx> 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.
![]() |
