Обсуждение: Avoiding empty queries in tsearch

Поиск
Список
Период
Сортировка

Avoiding empty queries in tsearch

От
"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
check if the resulting tsquery was empty or null, but haven't found a
way.  Any advice?
Thanks for your help,
Doug