[postgis-users] Newcomer-performance issue

[Michael Fuhr]

On Sun, Oct 01, 2006 at 08:30:25PM -0400, Carl Anderson wrote:
> First, I don't believe that functions are indexable in PostgreSQL

Expressions -- including function calls -- are indexable in PostgreSQL:

http://www.postgresql.org/docs/8.1/interactive/indexes-expressional.html

Functions must be IMMUTABLE to be indexable.

> Even if they are, I doubt you built such an index.

Probably not.

-- 
Michael Fuhr