Postgres function for full text search

From: - <grandebuzon(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Postgres function for full text search
Date: 2011-01-24 09:38:02
Message-ID: AANLkTimFoybT-79Eg2AYoK=7UENHvk09csDACED95+2+@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello everyone.
My question if any known one postgres function, for full text search that
separates words with "| "?
As plainto_tsquery separating words with "& ".

For example text "word1 word2 word3 word4"
and conversion rates for full text search postgres "word1 | word2 | word3 |
word4"

Or i must create an own function eg. on the java for normalize text for
search.
I guess there would not need to remove not allowed words from text to
prevent sql injection...?

Thanks and regards

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Filip Rembiałkowski 2011-01-24 09:49:13 Re: loosing data in postgres database
Previous Message victor katemana 2011-01-24 09:37:40 loosing data in postgres database