Re: Quick pointer required re indexing geometry - Mailing list pgsql-hackers

From Paul Matthews
Subject Re: Quick pointer required re indexing geometry
Date
Msg-id 4A81F78B.5050209@netspace.net.au
Whole thread Raw
In response to Re: Quick pointer required re indexing geometry  (Dimitri Fontaine <dfontaine@hi-media.com>)
List pgsql-hackers
Dimitri Fontaine wrote:<br /><blockquote cite="mid:87vdkuh2vk.fsf@hi-media-techno.com" type="cite"><pre wrap="">Paul
Matthews<a class="moz-txt-link-rfc2396E" href="mailto:plm@netspace.net.au"><plm@netspace.net.au></a> writes:
</pre><blockquotetype="cite"><pre wrap="">Witting a box@>point function easy. Having a spot of trouble trying to
 
figure out where and how to graft this into the GiST stuff. Could
someone please point me in the general direction?   </pre></blockquote><pre wrap="">
You want index support for it, I suppose? </pre></blockquote> Yes<br /><blockquote
cite="mid:87vdkuh2vk.fsf@hi-media-techno.com"type="cite"><pre wrap="">Without index support (but needed anyway), you
implementyour code in a
 
C module then make it visible from SQL.  ...cut... 
COMMENT ON OPERATOR @>(box, point) IS 'box contains point?'; </pre></blockquote> All done but the comment part :-)
<br/><blockquote cite="mid:87vdkuh2vk.fsf@hi-media-techno.com" type="cite"><pre wrap="">
 
Now for adding support for index lookups, you have to see documentation
about OPERATOR CLASS and OPERATOR FAMILY.
Hope this helps, regards, </pre></blockquote> Thanks overlooked CLASS and FAMILY in my hurry. Hopefully that is where
theproblem is.<br /><br /> What I am hoping to do is provide a "real" patch to make box@>point available for all.
Butwe can get to that later. A lot of code in pgsql, but not much in the way of comments.<br /> 

pgsql-hackers by date:

Previous
From: Gianni Ciolli
Date:
Subject: Re: "Hot standby"?
Next
From: Bruce Momjian
Date:
Subject: Re: Re: pgindent timing (was Re: [COMMITTERS] pgsql: Refactor NUM_cache_remove calls in error report path to a PG_TRY)