Using an index to materialize a function - Mailing list pgsql-general

From Robert James
Subject Using an index to materialize a function
Date
Msg-id CAGYyBgjahboymmn3ZbjRpC3MJdQ2FkDZ+NbUzbXd8Kj0QkcJCw@mail.gmail.com
Whole thread Raw
Responses Re: Using an index to materialize a function  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-general
If I have a slow_function(), and I create an index of
slow_function(field), will Postgres use that index to avoid having to
recompute the function?

Example:

SELECT slow_function(field1) FROM table1 WHERE id = 5

It won't use the index on field1 to _find_ the record.  Can it use it
to compute the field?


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Listing privileges on a schema
Next
From: Robert James
Date:
Subject: Does string a begin with string b?