Re: Determine index's attribute number by scankey

From: Victor Yegorov <viy(at)mits(dot)lv>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Postgres Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Determine index's attribute number by scankey
Date: 2005-07-14 20:35:40
Message-ID: 20050714203540.GA8458@mits.lv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Luke Lonergan 2005-07-14 21:13:17 Re: [Bizgres-general] A Guide to Constraint Exclusion (
Previous Message Simon Riggs 2005-07-14 20:34:00 Re: [Bizgres-general] A Guide to Constraint Exclusion