Re: Indexing on a circle datatype

Gavin Love <gavin(at)splicer(dot)org(dot)uk> writes:
> I seem to be unable to get postgres to use a gist index we have on a
> circle data type.
> SELECT id FROM tradesmen_profiles WHERE tradesmen_profiles.work_area
> @> point(0.0548691728419,51.5404384172);

So far as I can see, the member operators of gist circle_ops are

gist | circle_ops | <<(circle,circle)
gist | circle_ops | &<(circle,circle)
gist | circle_ops | &>(circle,circle)
gist | circle_ops | >>(circle,circle)
gist | circle_ops | <@(circle,circle)
gist | circle_ops | @>(circle,circle)
gist | circle_ops | ~=(circle,circle)
gist | circle_ops | &&(circle,circle)
gist | circle_ops | |>>(circle,circle)
gist | circle_ops | <<|(circle,circle)
gist | circle_ops | &<|(circle,circle)
gist | circle_ops | |&>(circle,circle)
gist | circle_ops | @(circle,circle)
gist | circle_ops | ~(circle,circle)

(this is extracted from the output of the query shown in 8.4 docs
section 11.9). So, circle @> point is out of luck. Try using a
zero- or small-radius circle on the right.

regards, tom lane