| Lists: | pgsql-hackers |
|---|
| From: | Naman <naman(dot)bbps(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Getting Tuples list from an index |
| Date: | 2013-10-21 22:19:22 |
| Message-ID: | CAO=k+Z858sivrCsdxu-SoNdYpMP4qygoLM3HVM503S7QxaKKQA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Hi
As a part of Course Project i have to implement this :
I have an 3 indexes on a relation t2(A,B,C) index1 , index2 ,index3
What i need is if i know the indexname (say index1) then is their any
programmatic way by which i can get the list of tuples which comes under
the index specified( i.e index1)
Regards
| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Naman *EXTERN*" <naman(dot)bbps(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Getting Tuples list from an index |
| Date: | 2013-10-22 09:39:07 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B17C502AA@ntex2010i.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Naman wrote:
> I have an 3 indexes on a relation t2(A,B,C) index1 , index2 ,index3
>
> What i need is if i know the indexname (say index1) then is their any programmatic way by which i can
> get the list of tuples which comes under the index specified( i.e index1)
Do you need anything that exceeds a catalog query?
Yours,
Laurenz Albe