Comment by masklinn
18 hours ago
That's the first solution (a function based index), however it has the drawback of fragility: a seemingly innocent change to the query can lead to not matching the index's expression anymore). Which is why the article moves on to generated columns.
No comments yet
Contribute on Hacker News ↗