Re: Quick pointer required re indexing geometry

From: Paul Matthews <plm(at)netspace(dot)net(dot)au>
To: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Quick pointer required re indexing geometry
Date: 2009-08-11 22:58:19
Message-ID: 4A81F78B.5050209@netspace.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Dimitri Fontaine wrote:<br>
<blockquote cite="mid:87vdkuh2vk(dot)fsf(at)hi-media-techno(dot)com" type="cite">
<pre wrap="">Paul Matthews <a class="moz-txt-link-rfc2396E" href="mailto:plm(at)netspace(dot)net(dot)au">&lt;plm(at)netspace(dot)net(dot)au&gt;</a> writes:
</pre>
<blockquote type="cite">
<pre wrap="">Witting a box@&gt;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(dot)fsf(at)hi-media-techno(dot)com" type="cite">
<pre wrap="">Without index support (but needed anyway), you implement your code in a
C module then make it visible from SQL. ...cut...
COMMENT ON OPERATOR @&gt;(box, point) IS 'box contains point?';
</pre>
</blockquote>
All done but the comment part :-) <br>
<blockquote cite="mid:87vdkuh2vk(dot)fsf(at)hi-media-techno(dot)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
the problem is.<br>
<br>
What I am hoping to do is provide a "real" patch to make box@&gt;point
available for all. But we can get to that later. A lot of code in
pgsql, but not much in the way of comments.<br>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.7 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2009-08-11 23:06:04 Re: Re: pgindent timing (was Re: [COMMITTERS] pgsql: Refactor NUM_cache_remove calls in error report path to a PG_TRY)
Previous Message Gianni Ciolli 2009-08-11 22:54:49 Re: "Hot standby"?