Re: nulls in GIN index - Mailing list pgsql-hackers

From worthy7
Subject Re: nulls in GIN index
Date
Msg-id 1407748676120-5814416.post@n5.nabble.com
Whole thread Raw
In response to Re: nulls in GIN index  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Responses Re: nulls in GIN index
List pgsql-hackers
Perhaps I'm missing something

Table has 2 columns, text and ftstext

text: "how are you"
ftstest: (nothing)

Because "how" and "are" and "you" are too common to be tsvectored. Which is
fine.

So if a user searches for "how are you":
select * from tbl_lines WHERE
ftstext @@ plainto_tsquery('English', 'how are you')

Returns nothing. Which I somewhat understand, but I want it to return all
the rows with nothing in the ftstext.
plainto_tsquery('English', 'how are you') = ''
and the ftstext of some rows is also = ''
So why doesn't the index return all these rows when a null string is
searched.

I think you can see what im trying to achieve, how do I do it?



--
View this message in context: http://postgresql.1045698.n5.nabble.com/nulls-in-GIN-index-tp5814384p5814416.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [REVIEW] pg_last_xact_insert_timestamp
Next
From: Fujii Masao
Date:
Subject: Re: [REVIEW] pg_last_xact_insert_timestamp