Re: Getting "could not read block" error when creating an index on a function.

[Christophe Pettus]

> On Dec 30, 2020, at 11:37, Demitri Muna <postgre...@demitri.com> wrote:
> I want to index the results of these repeated, unchanging calculations to 
> speed up other queries. Which mechanism would be best to do this? Create 
> additional columns? Create another table?

This might be a good use for a generated column.

        https://www.postgresql.org/docs/current/ddl-generated-columns.html
--
-- Christophe Pettus
   x...@thebuild.com