På mandag 11. august 2014 kl. 11:17:56, skrev worthy7 <[email protected]
<mailto:[email protected]>>: 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
[email protected] <mailto:[email protected]> www.visena.com
<https://www.visena.com> <https://www.visena.com>
