On Fri, 12 Oct 2001, Aasmund Midttun Godal wrote:
> Can someone shed some light on as to how the indexes actually work?
>
> I want to index the results of a function, the function does a whole
> lot of different selects on different tables. Will the database know
> when to update the index.
AFAIK No. The functions for functional indexes probably should only
depend upon the arguments and no outside data. Anything else sounds like
a recipe for broken indexes.