Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rémi Cura <remi(dot)cura(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index
Date: 2013-10-24 13:42:54
Message-ID: 25980.1382622174@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?UTF-8?Q?R=C3=A9mi_Cura?= <remi(dot)cura(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rémi Cura 2013-10-24 14:02:47 Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index
Previous Message Alban Hertroys 2013-10-24 13:42:31 Re: Replication and fsync