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

From Albert REINER
Subject UPDATE and INDEX on expensive function with (IsCachable)
Date
Msg-id 20010504115913.A557@frithjof
Whole thread Raw
Responses Re: UPDATE and INDEX on expensive function with (IsCachable)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
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? What if
the update explicitly re-sets table.field to its old value?

Thanks in advance,

Albert.


pgsql-novice by date:

Previous
From: "Bob Whitehouse"
Date:
Subject: Function Help
Next
From: Joel Burton
Date:
Subject: Re: Function Help