Skip site navigation (1) Skip section navigation (2)

Re: [NOVICE] Functional index problems. (Was: Many joins: monthly summaries S-L--O--W)

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Michael Glaesmann <grzm(at)myrealbox(dot)com>,pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [NOVICE] Functional index problems. (Was: Many joins: monthly summaries S-L--O--W)
Date: 2003-10-23 00:55:29
Message-ID: 200310221755.13446.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-sql
Michael,

> My final thought would be to continue using "functional index", noting 
> that operators are a special class of function. Out of the above 
> description of "value expression", I believe only functions and 
> operators are allowed as expressions in the CREATE INDEX syntax, 
> correct? (Besides referring to a column.)

Well argued.  The problem is Peter's point, which you weren't cc'd on:

>At least it's better than "functional index", because I had always
>wondered where the dysfunctional indexes went. :)


-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2003-10-23 02:53:58
Subject: Re: Functional index problems. (Was: Many joins: monthly summaries S-L--O--W)
Previous:From: Michael GlaesmannDate: 2003-10-23 00:32:53
Subject: Re: Functional index problems. (Was: Many joins: monthly summaries S-L--O--W)

pgsql-sql by date

Next:From: Tom LaneDate: 2003-10-23 02:53:58
Subject: Re: Functional index problems. (Was: Many joins: monthly summaries S-L--O--W)
Previous:From: Michael GlaesmannDate: 2003-10-23 00:32:53
Subject: Re: Functional index problems. (Was: Many joins: monthly summaries S-L--O--W)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group