logoalt Hacker News

masklinnyesterday at 8:32 PM0 repliesview on HN

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.