From: | worthy7 <worthy(dot)vii(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: nulls in GIN index |
Date: | 2014-08-11 09:17:56 |
Message-ID: | 1407748676120-5814416.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Fujii Masao | 2014-08-11 11:27:28 | Re: [REVIEW] pg_last_xact_insert_timestamp |
Previous Message | Andres Freund | 2014-08-11 07:46:23 | Re: [REVIEW] pg_last_xact_insert_timestamp |