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@xxxxxxxxxx, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
