Timeline for Optimizing a "categorized" search table using trigrams
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 7, 2020 at 22:25 | history | edited | CommunityBot |
added [postgresql-performance] to 571 questions - Shog9 (Id=1924)
|
|
| Jul 17, 2018 at 15:53 | vote | accept | brad | ||
| Jul 11, 2018 at 15:40 | answer | added | brad | timeline score: 1 | |
| May 14, 2018 at 19:25 | history | edited | brad | CC BY-SA 4.0 |
Fixed query to add parentheses
|
| May 14, 2018 at 3:06 | history | edited | Erwin Brandstetter |
tags
|
|
| May 14, 2018 at 3:00 | answer | added | Erwin Brandstetter | timeline score: 1 | |
| May 14, 2018 at 2:43 | comment | added | Erwin Brandstetter |
I assume you mean WHERE ( user_id = 123 OR user_id IS NULL ) AND search_on % 'mystring'? You need parentheses to keep AND binding before OR.
|
|
| May 14, 2018 at 2:41 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 |
tag, format
|
| May 14, 2018 at 1:43 | history | edited | brad | CC BY-SA 4.0 |
wrong field reference
|
| May 14, 2018 at 1:34 | history | asked | brad | CC BY-SA 4.0 |