<p><font size="2">Nick wrote:<br /><br /> > I have a VIEW that consists of two tables, of which contain a POINT<br
/>> column. When trying to select from the view I get an error...<br /> ><br /> > ERROR: could not identify
anordering operator for type point<br /> > HINT: Use an explicit ordering operator or modify the query.<br />
><br/> > Any suggestions??? -Nick<br /> ><br /><br /> I'm a lurker on this list (came for the 8.3 release,
stayedfor the delightful banter), but I have noticed that seems to be a real issue, at least for the moment.<br /><br
/>Not trying to be snotty, but perhaps using postGIS <<a
href="http://postgis.refractions.net/">http://postgis.refractions.net/</a>>would be a suitable alternate ? It does
requireadmin rights to install but the point does have an equality op, GIST indexing and is reasonably light-weight in
diskspace.<br /><br /> Ok, you probably already rejected this for good reason ... back to the real thread.<br /><br />
Apologiesfor the signage below ...<br /><br /> Greg Williamson<br /> Senior DBA<br /> DigitalGlobe<br /><br />
ConfidentialityNotice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s)
andmay contain confidential and privileged information and must be protected in accordance with those provisions. Any
unauthorizedreview, use, disclosure or distribution is prohibited. If you are not the intended recipient, please
contactthe sender by reply e-mail and destroy all copies of the original message.<br /><br /> (My corporate masters
mademe say this.)<br /></font>
