On Thu, 25 Jun 2009, Henk van Lingen wrote:
>
> Hi,
>
> How can I add a character as space symbol for the full text search indexes?
>
> I'm adding firewall syslog lines in a database (8.3.7), and have a GIN
> index on the message field. I'd like the slash considered a space symbol,
> so i can search for IPnumbers in test like
>
> world/123.456.192.46(0) -> some-fwsm/123.456.221.121(0)
preprocess text, for example, using replace(), regexp_replace() functions
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83