| 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
| 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 |