News for hackers. Stuff that matters.
Re:Selecting All Columns Except One in PostgreSQL by blattimwind on Saturday May 19, 2018 @10:36AM (#17108039)
Writing "SELECT *" makes it less clear what columns are selected exactly. Explicitly writing what columns shall be returned is more explicit and clear.
Re:Selecting All Columns Except One in PostgreSQL by MichaelApproved on Saturday May 19, 2018 @11:08AM (#17108165)
That's helpful from a code review perspective but it's the performance hit you get with a * select that is the bigger reason to avoid it.
Re:Selecting All Columns Except One in PostgreSQL by dahdum on Saturday May 19, 2018 @11:36AM (#17108285)
The column name conflicts can cause no end of trouble later on as well.