Re: How can I index a substring attribute?

Поиск
Список
Период
Сортировка
От Thiemo Kellner
Тема Re: How can I index a substring attribute?
Дата
Msg-id 200308140720.31068.thiemo@thiam.ch
обсуждение исходный текст
Ответ на Re: How can I index a substring attribute?  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-novice
Am Donnerstag, 14. August 2003 01.22 schrieb Stephan Szabo:
> On Thu, 14 Aug 2003, Thiemo Kellner wrote:
> > I try to have an index that only contains substrings of an attribute.
> > (This is for a try of a port of a MySQL repository).
>
> For 7.3 and earlier, you'll need to wrap the substr in another function
> that takes just Name and passes the arguments because the functional
> indexes won't take the constant arguments.
>
> In 7.4 the indexes are more powerful and can do this directly (and many
> more things too).

So, if I understand right, I have to make my own function to wrap subst,
haven't I?

Thanks for advice.

Cheers,

Thiemo

--
root ist die Wurzel allen Übels


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

Предыдущее
От: Cath Lawrence
Дата:
Сообщение: Large object - what's happening?
Следующее
От: "mathan"
Дата:
Сообщение: Ho to test Miscellaneous Functions