Re: gist index on cube column

On Sat, Jun 09, 2007 at 07:40:05PM -0400, ABHANG RANE wrote:
> Hi,
> I had some doubts about the gist index on cube column. So if I have a 
> column of type cube and create a gist index on it, would the index be 
> on individual elements in the cube or the cube as a whole. I mean will 
> a gist index on cube column improve the performance of earthdistance 
> function or cube_distance function.

The index will work on any operators the index is defined to work on.
So I suggest looking at the documentation for what operators are
defined and whether they solve your problem.

Have a nice day,
-- 
Martijn van Oosterhout      http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.