* Tom Lane <[EMAIL PROTECTED]> [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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to