Re: [PERFORM] Indexing on a circle datatype

Tom Lane wrote: Gavin Love 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 g

[PERFORM] Indexing on a circle datatype

Hey, I seem to be unable to get postgres to use a gist index we have on a circle data type. Table "public.tradesmen_profiles" Column |Type | Modifiers ---+-+--- id