On Thu, May 19, 2011 at 12:36 AM, Tim Uckun <[email protected]> wrote: > I started looking through the documentation today. I don't see any > references to sphinx like operators. For example "this | that" "this > -that" etc. > > Do you know if that's possible with tsearch?
Queries are made using SQL, so you can use OR and NOT the same as querying on any other kind of attribute. Most search engines have only a "search for these terms" operation, but Postgresql's implementation is just another type of index which you can query against, and you're free to write whatever logic you want around that. But there is a choice of functions if you want to use the pre-built rules for converting website search queries into SQL conditions - one is for plain text only, the other I believe will do the boolean searching stuff. You can write your own conversion easily too if you want to invent your own search syntaxes. You can also do fancy things with the term index query operators themselves (see http://linuxgazette.net/164/sephton.html), but you'll probably be happier starting off with combining individual searches using more familiar query logic. -- You received this message because you are subscribed to the Google Groups "WellRailed" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/wellrailed?hl=en.
