find close (duplicate) points + create index

Elinor Medezinski <elinor@bellatrix.tau.ac.il>

From: Elinor Medezinski <elinor@bellatrix.tau.ac.il>
To: pgsql-novice@postgresql.org
Cc: elinor@wise.tau.ac.il
Date: 2004-03-04T10:42:23Z
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