Hi all,
i am a master's student. I have to do a keyword search for spatial
database. I have the data set of a particular district in India. I
have a data model too.
Can some one help me through this task.

My question is - it is a single word (keyword) search. I have the
database schema too. How do i search this keyword through this schema
or the entire data. How do i convert this keyword into a sql query
that the database system would understand and query the database.
Eg keyword- river.

I would appreciate advice.
TIA.

On Tue, 05 Jan 2010 23:26:05 -0800, Kavita wrote:

You can do a text search on a single column with a text index. You should
do something like this:
WHERE text_srch_col @@ to_tsquery('keyword & ice')

You can not do a search the entire schema.


--
http://mgogala.byethost5.com

Kavita wrote:
I don't understand.

What do you mean by "spatial database"? PostGIS?
What is a "keyword search"?

Maybe you could post a little example...

Yours,
Laurenz Albe