find close (duplicate) points + create index

Поиск
Список
Период
Сортировка
От Elinor Medezinski
Тема find close (duplicate) points + create index
Дата
Msg-id 200403041242.23872.elinor@bellatrix.tau.ac.il
обсуждение исходный текст
Ответы Re: find close (duplicate) points + create index
Re: find close (duplicate) points + create index
Список 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

В списке pgsql-novice по дате отправления:

Предыдущее
От: tully
Дата:
Сообщение: Re: Column Headings using Comment?
Следующее
От: googleplex6000@yahoo.com (Joe)
Дата:
Сообщение: Re: Initializing tables from flat files