Sam Mason <sam@samason.me.uk> writes:
> On Thu, Apr 16, 2009 at 11:29:25AM -0400, Tom Lane wrote:
>> , a full table indexscan isn't going to be particularly fast in
>> any case; it's often the case that seqscan-and-sort is the right
>> decision.
> Is PG capable of "skipping" over duplicate values using an index?
No, not at present. It's on the TODO list.
regards, tom lane