Timeline for Unused columns in WHERE clause
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 7, 2022 at 14:58 | comment | added | Barmar |
You may be right about ORDER BY ... LIMIT ... in a historical version. Sqlite allows you to use those clauses directly in DELETE without a subquery, but maybe PostgreSQL doesn't.
|
|
| Apr 7, 2022 at 9:00 | history | tweeted | twitter.com/StackDBAs/status/1511992190008012800 | ||
| Apr 6, 2022 at 23:53 | history | became hot network question | |||
| Apr 6, 2022 at 22:43 | comment | added | lonix | @Akina Thanks that is a good tip. In this case though they are both declared as non-null. | |
| Apr 6, 2022 at 22:40 | vote | accept | lonix | ||
| Apr 6, 2022 at 17:41 | comment | added | Akina |
What will happen to the record that has Id = NULL? What will happen to the record that has CreatedAt = NULL? Think. Then test both queries...
|
|
| Apr 6, 2022 at 16:00 | answer | added | Laurenz Albe | timeline score: 13 | |
| Apr 6, 2022 at 15:48 | history | asked | lonix | CC BY-SA 4.0 |