Home > mailing lists

relaxed full text search? - Mailing list pgsql-novice

From	Steven Marcus
Subject	relaxed full text search?
Date	February 5, 2016 05:17:32
Msg-id	CAPQGwohfwJLEchdiHjEV-F46Ne+qZPAZBg+QDHds4aO8DtaLNg@mail.gmail.com Whole thread Raw
Responses	Re: relaxed full text search? (Tom Lane <tgl@sss.pgh.pa.us>)
List	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

A: 10 Addison Road Marrickville NSW 2204

From: Daniel Tordable Dasilva
Date: 03 February 2016, 21:38:36
Subject: Re: Cannot initdb on fresh install

From: Steven Marcus
Date: 05 February 2016, 06:35:27
Subject: Re: relaxed full text search?