Re: index on user defined type

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: index on user defined type
Дата
Msg-id 2316.1105571557@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: index on user defined type  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Ответы Re: index on user defined type  (Jeff Davis <jdavis-pgsql@empires.org>)
Список pgsql-general
Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
> I'm wondering if the function under = is an SQL function being inlined.

Bingo --- that's surely it.  After inlining, the expression would no
longer look like it matched the index.

You don't want to use SQL functions to define indexable operators
anyway.  They leak memory, and are slow, and neither of those are
good properties for an index support function.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: "Joost Kraaijeveld"
Дата:
Сообщение: Re: How to return a resultset/table from a sql function?
Следующее
От: MargaretGillon@chromalloy.com
Дата:
Сообщение: Re: Postgresql Text field / Visual FoxPro Memo and ODBC