Yeah, I would think functional/function-based indexes should be mentioned. Add an index or add a redundant column? Almost all of time I would prefer the index.

Of course if your database can't be changed then maybe you can use this trick if there is already a suitable indexed column.