Make a table of unique words from text Column?

Поиск
Список
Период
Сортировка
От Phillip J. Allen
Тема Make a table of unique words from text Column?
Дата
Msg-id 3D91D476.80502@attglobal.net
обсуждение исходный текст
Список pgsql-novice
Hi all,

It is time for me to start data mining a data base.

 I have table with 4 fields east(float8), north(float8),
elevation(float8) and memo (varchar).  As you can tell this is a GIS
data.  The memo field consists of descriptions transcribed from a map.
 Now these descriptions were written over a peroid of 40-50 years by
various authors.  So spelling has changed (complete words and
abbreviations) and english to spanish.

I want to scan throught this memo field and make a unique word list and
drop it into a new table.  Then I can see exactly what words they used
and can start to filter and re-organized it into something usefull and
turn it into a thematic map.

Any suggestions where to begin?

Thanks,

Phillip J. Allen
Consulting Geochemist/Geologist
Lima Peru
e-mail: paallen@attglobal.net




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

Предыдущее
От: "Steinn E. Sigurdarson"
Дата:
Сообщение: pgcrypto?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: install problem