Re: Backwards index scan - Mailing list pgsql-general

From Dmitry Tkach
Subject Re: Backwards index scan
Date
Msg-id 3F09ED1D.10106@openratings.com
Whole thread Raw
In response to Re: Backwards index scan  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
>
>
>If you make an opclass that orders in the reverse order you can use that
>opclass in creating the index (which effectively can give you an index
>like x, y desc by using the new opclass on y).  There was some talk
>recently about whether we should provide such opclasses as builtins or
>contrib items.
>
>
Ah! Nice :-)
I did not think about  it...

Thanks a lot for the hit!

Dima


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Backwards index scan
Next
From: Mike Mascari
Date:
Subject: Re: making multiple updates use indexes: howto?