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

From Andreas Joseph Krogh
Subject Re: nulls in GIN index
Date
Msg-id VisenaEmail.2a.8edce5afe0de16c5.147c5a0b718@tc7-on
Whole thread Raw
In response to Re: nulls in GIN index  (worthy7 <worthy.vii@gmail.com>)
List pgsql-hackers
På mandag 11. august 2014 kl. 11:17:56, skrev worthy7 <worthy.vii@gmail.com>:
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?
 
Use the 'simple' dictionary:
 
my_fts_column @@ to_tsquery('simple', 'how are you')
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment

pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Proposal to add a QNX 6.5 port to PostgreSQL
Next
From: Stephen Frost
Date:
Subject: Re: Hokey wrong versions of libpq in apt.postgresql.org