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

From Josh Berkus
Subject Re: [NOVICE] Functional index problems. (Was: Many joins: monthly summaries S-L--O--W)
Date
Msg-id 200310221755.13446.josh@agliodbs.com
Whole thread Raw
List pgsql-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 BerkusAglio Database SolutionsSan Francisco



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query planner: current_* vs. explicit date
Next
From: Abdul Wahab Dahalan
Date:
Subject: List table with same column name