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 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

[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