CODEWITHSUNDEEP
postgresqltsvector
itsame69
itsame69

Reputation: 1570

PostgreSQL tsvector tsquery Bug?

is this a bug or a feature? I've created an index on a tsvector attribute (without using a dictionary).

The query

SELECT title
FROM table
WHERE title_tsv @@ to_tsquery('basic') and
title_tsv @@ to_tsquery('inst:*')

returns "Basic Instinct". However, the query

SELECT title
FROM table
WHERE title_tsv @@ to_tsquery('basic') and
title_tsv @@ to_tsquery('in:*')

returns no records at all. I don't see why the second (more generic query) returns less results then the first query?

Bye

Upvotes: 4

Views: 1539

Answers (1)

araqnid
araqnid

Reputation: 133692

steve@steve@[local] =# select to_tsquery('in:*');
NOTICE:  text-search query contains only stop words or doesn't contain lexemes, ignored

so presumably matching against that query always returns false?

Maybe you want to be making a single query of the form 'basic & in:*' ?

Upvotes: 4

Related Questions