Re: Determine index's attribute number by scankey - Mailing list pgsql-hackers

From Victor Yegorov
Subject Re: Determine index's attribute number by scankey
Date
Msg-id 20050714203540.GA8458@mits.lv
Whole thread Raw
In response to Re: Determine index's attribute number by scankey  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
* 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


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [Bizgres-general] A Guide to Constraint Exclusion
Next
From: "Luke Lonergan"
Date:
Subject: Re: [Bizgres-general] A Guide to Constraint Exclusion (