Creating a custom email token parser for FTS

From: Brian Ghidinelli <brian(at)pukkasoft(dot)com>
To: SF Postgres <sfpug(at)postgresql(dot)org>
Subject: Creating a custom email token parser for FTS
Date: 2014-01-15 02:09:42
Message-ID: 52D5EDE6.2030307@pukkasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: sfpug


I've looked through the docs but I'm not clear on how, or if it's
possible, to create a new token for FTS?

Specifically I would like a variant of the email token that breaks it up
into username, host, domain and drops the TLD so we can do partial
searching. I'd like to change it so this doesn't fail:

select to_tsvector('brian(at)hotmail(dot)com') @@ to_tsquery('hotmail')

How can a new token be added? Or update an existing token?

Brian

Responses

Browse sfpug by date

  From Date Subject
Next Message Josh Berkus 2014-01-16 00:08:50 The uselessness of pgbouncer PAUSE
Previous Message David Fetter 2014-01-08 22:39:11 Re: Slow 1st queries and RAM size