Re: [GENERAL] Avoiding empty queries in tsearch

2007-01-16 Thread Doug Cole
That sounds perfect, but it doesn't seem to exist on either of the postgresql installations I have access to (8.1 on ubuntu and fedora core). Is it new to 8.2? Is there a similar function under 8.1, or at least a decent work-around? Thanks for the help, Doug On 1/15/07, Teodor Sigaev <[EMAIL PR

Re: [GENERAL] Avoiding empty queries in tsearch

2007-01-15 Thread Oleg Bartunov
Doug, numnode exists for sure ! It's plainto_tsquery function which Teodor used in example, appeared in 8.2 Oleg On Mon, 15 Jan 2007, Doug Cole wrote: That sounds perfect, but it doesn't seem to exist on either of the postgresql installations I have access to (8.1 on ubuntu and fedora core).

Re: [GENERAL] Avoiding empty queries in tsearch

2007-01-15 Thread Teodor Sigaev
Doug Cole wrote: That sounds perfect, but it doesn't seem to exist on either of the postgresql installations I have access to (8.1 on ubuntu and fedora core). Is it new to 8.2? Is there a similar function under 8.1, or at Yes, it's new in 8.2 least a decent work-around? Thanks for the h

Re: [GENERAL] Avoiding empty queries in tsearch

2007-01-15 Thread Doug Cole
That sounds perfect, but it doesn't seem to exist on either of the postgresql installations I have access to (8.1 on ubuntu and fedora core). Is it new to 8.2? Is there a similar function under 8.1, or at least a decent work-around? Thanks for the help, Doug On 1/15/07, Teodor Sigaev <[EMAIL

Re: [GENERAL] Avoiding empty queries in tsearch

2007-01-15 Thread Teodor Sigaev
contrib_regression=# select numnode( plainto_tsquery('the any') ); NOTICE: query contains only stopword(s) or doesn't contain lexeme(s), ignored numnode - 0 (1 row) contrib_regression=# select numnode( plainto_tsquery('the table') ); numnode - 1 (1 row) contrib_r

[GENERAL] Avoiding empty queries in tsearch

2007-01-15 Thread Doug Cole
I am having trouble with to_tsquery when the query is all stop words. Rather than return everything as a match, it returns nothing with the notice: NOTICE: Query contains only stopword(s) or doesn't contain lexem(s), ignored What is the best way to check for this, I was hoping to be able to che

[GENERAL] Avoiding empty queries in tsearch

2007-01-14 Thread Doug Cole
I am having trouble with to_tsquery when the query is all stop words. Rather than return everything as a match, it returns nothing with the notice: NOTICE: Query contains only stopword(s) or doesn't contain lexem(s), ignored What is the best way to check for this, I was hoping to be able to che