Preparing full text search input for use in PostgreSQL 8.3 - Mailing list pgsql-general

From Rudolph
Subject Preparing full text search input for use in PostgreSQL 8.3
Date
Msg-id 9bbc92ca-fda7-48da-b80d-eb0a073f0061@s37g2000prg.googlegroups.com
Whole thread Raw
List 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

pgsql-general by date:

Previous
From: "David Wilson"
Date:
Subject: select distinct and index usage
Next
From: "Guillaume Bog"
Date:
Subject: Re: pl/pgsql RECORD data type, how to access to the values