Re: create index on function - why?

Due to time constraints, I do not directly answer general PostgreSQL
questions.  For assistance, please join the appropriate mailing list and
post your question:
http://www.postgresql.org/users-lounge

You can also try the #postgresql IRC channel.  See the PostgreSQL FAQ
for more information.

---------------------------------------------------------------------------


Wei Weng wrote:
> I can understand the rationale behind creating index on tables, it 
> speeds up the searching.
> 
> But what is the rationale behind creating index on a function? how does 
> it help with the database performance?
> 
> Thank you.
> 
> -- 
> Wei Weng
> Network Software Engineer
> KenCast Inc.
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> 
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us root@candle.pha.pa.us                |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026