Index scan troubles

Поиск
Список
Период
Сортировка
От Markus Wanner
Тема Index scan troubles
Дата
Msg-id 48BD652D.9060303@bluegap.ch
обсуждение исходный текст
Ответы Re: Index scan troubles
Re: Index scan troubles
Список pgsql-hackers
Hi,

I'm having a hard time using an index scan. So far, I've done quite well 
with ScanKeyInit for equality searches. But now I need to scan an index 
from a given starting point. Something like:
   (x, y, z,...) > (const, const, const,...)

For the equality operatior, I've used get_sort_group_operators() in 
combination with get_opcode() to pass that on as the sk_func of the scan 
key. I slowly begin to doubt if that's correct at all.

While it works for equality scans, it does somehow not work for for 
BTGreaterStrategy. What am I missing?

I do have the following: an indexStruct on the index (primary key) I 
want to use, a TupleDescriptor for the relation I want tuples from and 
of course the list of constants (datums) to compare against. I want to 
do an index scan to retrieve tuples from that given lower bound upwards 
(or forwards).

I don't quite grok all the opfamily and opclass things, yet. Hints and 
pointers on where to read on greatly appreciated. A virtual beer for 
sample code. ;-)

Regards

Markus Wanner


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

Предыдущее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: What is d2mdir?
Следующее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: What is d2mdir?