Re: [GENERAL] Full-Text Searching: to_tsquery() vs. plainto_tsquery()

2009-09-04 Thread Oleg Bartunov
APseudoUtopia, you invented your own query language, so you should write your own function, which transforms user's query to ::tsquery, if to_tsquery() and plainto_tsquery() doesn't satisfy your input language. Notice, that phrase search will be able only in 8.5 version. Oleg On Fri, 4 Sep

[GENERAL] Full-Text Searching: to_tsquery() vs. plainto_tsquery()

2009-09-04 Thread APseudoUtopia
Hello, I'm working on setting up a full-text search for some descriptions stored in my database. I'm running pg 8.4. >From what I can tell, there are two functions. One function, to_tsquery(), requires that boolean operators (&, |, !) are between every word. The other function, plainto_tsquery()