Re: Indexing varchar fields with lower()

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Indexing varchar fields with lower()
Дата
Msg-id 7012.957544435@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Indexing varchar fields with lower()  ("Mitch Vincent" <mitch@huntsvilleal.com>)
Список pgsql-hackers
"Mitch Vincent" <mitch@huntsvilleal.com> writes:
> Could putting that function in there even though it's not 'built-in' cause
> any problems that you can think of? (Mainly worried about any kind of index
> corruption like I've seen before)

No, shouldn't be a problem.  The only thing non "built in" about it is
that fmgr.c has to find the function by name rather than by OID (there's
a shortcut for the OIDs of the standard pg_proc entries).  So the lookup
is a tad slower, that's all.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 7.0RC2 compile error !
Следующее
От: The Hermit Hacker
Дата:
Сообщение: RFP: PostgreSQL Replication ...