relaxed full text search?

From: Steven Marcus <steven(at)silvertrak(dot)com(dot)au>
To: pgsql-novice(at)postgresql(dot)org
Subject: relaxed full text search?
Date: 2016-02-05 02:17:27
Message-ID: CAPQGwohfwJLEchdiHjEV-F46Ne+qZPAZBg+QDHds4aO8DtaLNg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

My first implementation of full text search is generally working -- but I'd
like to be able to relax the matching rules.

For example, searching for "salmon" does not find "salmonella" as
configured out of the box for postgresql 9.3.10.

Here's my, probably naive, query:
SELECT * FROM table WHERE tsv @@ plainto_tsquery('salmon');

I've read the docs and searched via google -- and learnt a lot.
But I don't understand how to bend the full text search feature to do what
I want?

Thanks for any help,
Steven

--
*Steven Marcus*
Software Development Manager

*P: *+61 2 9007 5600
*E: *steven(at)silvertrak(dot)com(dot)au
*A: *10 Addison Road Marrickville NSW 2204

www.silvertrak.com.au

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Steven Marcus 2016-02-05 03:35:22 Re: relaxed full text search?
Previous Message Daniel Tordable Dasilva 2016-02-03 18:38:26 Re: Cannot initdb on fresh install