Re: [GENERAL] "IN" in a geometric database using data type "point"

2010-09-26 Thread Andrew Hunter
but this request returns me an error: operator doesn't exist point = point. > so i tried to use a path unstead of list of point like this: > 'SELECT * FROM map WHERE position <@ path '(point(-1,-1), (point(1,-1), > point(1,1), point(-1,1))' > but this request re

Re: [GENERAL] Visualize GiST Index

2010-09-23 Thread Andrew Hunter
Hi Tom, Thanks very much for your assistance, your suggestion worked a treat. I have updated the gevel people. Regards Andrew On 2010-09-23, at 2:05 PM, Tom Lane wrote: > Andrew Hunter writes: >> Here is the content of the gevel Makefile > >> subdir = contrib/gev

Re: [GENERAL] Visualize GiST Index

2010-09-23 Thread Andrew Hunter
On 2010-09-23, at 10:27 AM, Tom Lane wrote: > Andrew Hunter writes: >> On 2010-09-22, at 9:56 PM, Tom Lane wrote: >>> Andrew Hunter writes: >>>> I have been trying to install the Gevel module but am getting an error >>>> when running make on t

Re: [GENERAL] Visualize GiST Index

2010-09-22 Thread Andrew Hunter
On 2010-09-22, at 9:56 PM, Tom Lane wrote: > Andrew Hunter writes: >> I have been trying to install the Gevel module but am getting an error when >> running make on the gevel files download. >> The error is: > >> /contrib/contrib-global.mk: No such file or dire

[GENERAL] Visualize GiST Index

2010-09-21 Thread Andrew Hunter
have postgresql 8.4.4 on ubuntu 9.10. If anybody has any pointers on how to install the gevel module I'd appreciate hearing them. Thanks Andrew Hunter PEng RPSurv PhD Assistant Professor Department of Geomatics Engineering Schulich School of Engineering University of Calgary T: +403.220.7