Postgres Pro
Downloads
Home   >   mailing lists

Re: UPDATE and INDEX on expensive function with (IsCachable) - Mailing list pgsql-novice

From Tom Lane
Subject Re: UPDATE and INDEX on expensive function with (IsCachable)
Date
Msg-id 25682.988994492@sss.pgh.pa.us
Whole thread Raw
In response to UPDATE and INDEX on expensive function with (IsCachable)  ("Albert REINER" <areiner@tph.tuwien.ac.at>)
List pgsql-novice
Tree view 
"Albert REINER" <areiner@tph.tuwien.ac.at> writes:
> Suppose some _cachable_ function f is expensive, but its results are
> often needed.  So, to speed up queries, we have an index on
> f(table.field). I wonder what happens when we update a tuple of that
> table: will f be re-computed if table.field is not changed?

Yes.

            regards, tom lane

pgsql-novice by date:

Previous
From: Joel Burton
Date:
Subject: Re: Function Help
Next
From: "suhail sarwar"
Date:
Subject: Variables in SQL statements