| From: | Greg Stark <gsstark(at)mit(dot)edu> |
|---|---|
| To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
| Cc: | Greg Stark <gsstark(at)mit(dot)edu>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Scan Keys |
| Date: | 2006-07-06 01:14:21 |
| Message-ID: | 871wszpmaa.fsf@stark.xeocode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> The info you need is in the operator class. In a sense you do need to
> know the type of index you're scanning, not all indexes use the same
> strategy numbers.
Well what was tripping me up was figuring out the operator class. I just
realized it's in the index's Relation object.
But yes what you describe is really a problem. Even given the operator class
there's no way for me to know which strategy number to pick. There might not
be any strategy number for equals in which case I'm in trouble.
--
greg
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-07-06 02:18:20 | Re: pgstattuple extension for indexes |
| Previous Message | Joshua D. Drake | 2006-07-06 00:57:08 | Re: lastval exposes information that currval does not |