Preparing full text search input for use in PostgreSQL 8.3

From: Rudolph <rudolph(dot)froger(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Preparing full text search input for use in PostgreSQL 8.3
Date: 2008-04-06 20:43:05
Message-ID: 9bbc92ca-fda7-48da-b80d-eb0a073f0061@s37g2000prg.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

It's nice that we have plainto_tsquery in addition to to_tsquery
because it's syntax is closer to what end users are used to (more like
Google search syntax with it's implicit "AND"). plainto_tsquery
however "cannot recognize either Boolean operators or weight
labels" (see: http://www.postgresql.org/docs/8.3/interactive/textsearch-controls.html#TEXTSEARCH-PARSING-QUERIES)
I wonder if anyone knows an open source project that created a piece
of code that parses any user input and converts it into proper query
syntax for to_tsquery (or returns an error message if no proper query
can be contructed).

Thanks!

Rudolph

Browse pgsql-general by date

  From Date Subject
Next Message David Wilson 2008-04-06 23:32:58 select distinct and index usage
Previous Message Tino Wildenhain 2008-04-06 18:28:59 Re: modules