Re: [HACKERS] nulls in GIN index

På mandag 11. august 2014 kl. 11:17:56, skrev worthy7 mailto:worthy@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 se

Re: [HACKERS] nulls in GIN index

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

Re: [HACKERS] nulls in GIN index

On 08/11/2014 01:19 AM, worthy7 wrote: http://www.postgresql.org/docs/9.1/static/gin-implementation.html """As of PostgreSQL 9.1, NULL key values can be included in the index. Also, placeholder NULLs are included in the index for indexed items that are NULL or contain no keys according to extrac

[HACKERS] nulls in GIN index

http://www.postgresql.org/docs/9.1/static/gin-implementation.html """As of PostgreSQL 9.1, NULL key values can be included in the index. Also, placeholder NULLs are included in the index for indexed items that are NULL or contain no keys according to extractValue. This allows searches that should