creating functional index over multiple columns

Поиск
Список
Период
Сортировка
От Chantal Ackermann
Тема creating functional index over multiple columns
Дата
Msg-id 3D1C44DD.9040400@biomax.de
обсуждение исходный текст
Список pgsql-sql
hello all,

I am new to this list, and I hope my request is well placed, here. I 
tried searching the archives but I wasn't lucky.

I want to create an index over two columns and one function:

the WHERE clause is:
WHERE lower(name)=? AND type_id=? AND syn_id=?

I know from the docs that I have to create on function that wraps these 
three values for creating the appropriate index. I have practically no 
idea how to do this (e.g. what type/set should this function return?).

Thanks a lot for pointers to documentation/former postings or any help
Cheers
Chantal





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

Предыдущее
От: Karel Zak
Дата:
Сообщение: Re: to_char() and order-by
Следующее
От: Chantal Ackermann
Дата:
Сообщение: Re: creating functional index over multiple columns