Обсуждение: Determine index's attribute number by scankey

Hello.

Is it possible to somehow determine index's attribute number that is target
one for given scankey?


I've checked nbtree AM code and found no evidence of such an ability. I need
that, because I'm storing each indexed value only once in a form of index
tuple, consisting of only 1 attribute.

If that's not possible now, I'd like to add sk_index_attnum entry to the
ScanKeyData structure.


-- 

Victor Y. Yegorov

Victor Yegorov <viy@mits.lv> writes:
> Is it possible to somehow determine index's attribute number that is target
> one for given scankey?

sk_attno?
        regards, tom lane

* Tom Lane <tgl@sss.pgh.pa.us> [14.07.2005 01:00]:
> sk_attno?

It seems, that sk_attno holds number of scankey itself.

I have table with 3 columns (a, b, c) and index (b, c).
For both selects (only 1 where clause in both of them):
   select * from tab where b = ...

and
   select * from tab where c = ...


sk_attno reports 0, that made me think of adding new entry to the scankey.


-- 

Victor Y. Yegorov