Re: cube_contains and indexing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: cube_contains and indexing
Date: 2002-08-18 01:02:43
Message-ID: 6737.1029632563@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bruno Wolff III <bruno(at)wolff(dot)to> writes:
> I am playing around with the cube extension in contrib and was not able to
> get cube_contains to use an index. I was able to get (what I believe to be)
> an equivalent @ operation (cubement containment) to use indexes.
> So I am either confused about there being a @ equivalent to cube_contains
> or cube_contains should be an indexable operation but isn't (or at least
> is harder to get to use an index).

It says here (cube.sql.in) that the @ operator *is* cube_contains.
Also, AFAICT both @ and ~ (the commutator operator, cube_contained)
should be equally indexable. Can you show us your test case?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lee Harr 2002-08-18 01:04:49 Re: Permission Error when starting PostgreSQL
Previous Message Bruno Wolff III 2002-08-17 20:51:48 cube_contains and indexing