find close (duplicate) points + create index

From: Elinor Medezinski <elinor(at)bellatrix(dot)tau(dot)ac(dot)il>
To: pgsql-novice(at)postgresql(dot)org
Cc: elinor(at)wise(dot)tau(dot)ac(dot)il
Subject: find close (duplicate) points + create index
Date: 2004-03-04 10:42:23
Message-ID: 200403041242.23872.elinor@bellatrix.tau.ac.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

I have a table with one column --
"CREATE TABLE pointtable (point POINT)".
I'm trying to find duplicate entries, where two entries are considered
duplicates if they're within a radius of 1, meaning something like ~ "select
point from pointtable where distance between points <=1".
Obviously this is not SQL syntax. Is there a way to do this - search within a
column itself?

Also, I also tried to build an index on that column, but there's no operator
class for type point. How can I do that?

Thanks,
Elinor

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Scott Goodwin 2004-03-04 14:21:24 Re: Merging multiple values into comma-delimited list in a view
Previous Message Bruno Wolff III 2004-03-04 06:15:53 Re: Merging multiple values into comma-delimited list in a view