| From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
|---|---|
| To: | Henk van Lingen <H(dot)G(dot)K(dot)vanLingen(at)uu(dot)nl> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Add Space symbols for TSvector |
| Date: | 2009-06-25 09:05:41 |
| Message-ID: | Pine.LNX.4.64.0906251303460.17118@sn.sai.msu.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Miao Jiang | 2009-06-25 09:12:39 | why the similar query takes so difference time in tsearch2? |
| Previous Message | Henk van Lingen | 2009-06-25 08:46:46 | Add Space symbols for TSvector |