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

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: [NOVICE] Functional index problems. (Was: Many joins: monthly summaries S-L--O--W)
Дата
Msg-id 200310221755.13446.josh@agliodbs.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Query planner: current_* vs. explicit date
Следующее
От: Abdul Wahab Dahalan
Дата:
Сообщение: List table with same column name