Postgres Pro
Downloads
Home   >   mailing lists

Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index - Mailing list pgsql-general

From Tom Lane
Subject Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index
Date
Msg-id 25980.1382622174@sss.pgh.pa.us
Whole thread Raw
In response to GIST index : order Hack : getting the order used by CLUSTER .. USING my_index  (Rémi Cura <remi.cura@gmail.com>)
Responses Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index  (Rémi Cura <remi.cura@gmail.com>)
List pgsql-general
Tree view 
=?UTF-8?Q?R=C3=A9mi_Cura?= <remi.cura@gmail.com> writes:
> I would like to be able to get the rows following the order of an index
> (*NOT* getting an order by accelerated, but only an order defined by an
> index).

Since a GiST index hasn't got any specific internal order, I fail to see
the point of this.

            regards, tom lane

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Replication and fsync
Next
From: Rémi Cura
Date:
Subject: Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index