Re: [GENERAL] Add Space symbols for TSvector

2009-06-25 Thread Arjen Nienhuis
> > preprocess text, for example, using replace(), regexp_replace() functions > > Oke, you mean at the time the insert in de db is done, i suppose. > However, I'm using the new syslog-ng 3 feature which does the > insert directly. So I have to change the syslogd for that. > > I understand the ts_se

Re: [GENERAL] Add Space symbols for TSvector

2009-06-25 Thread Tom Lane
Henk van Lingen writes: > I understand the ts_search parser is not configurable? You can substitute your own parser, but the built-in one doesn't have any provisions for fine-grained configuration. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@

Re: [GENERAL] Add Space symbols for TSvector

2009-06-25 Thread Henk van Lingen
On Thu, Jun 25, 2009 at 01:05:41PM +0400, Oleg Bartunov wrote: >> >> 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,

Re: [GENERAL] Add Space symbols for TSvector

2009-06-25 Thread Oleg Bartunov
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 IPnu