Re: [GENERAL] Comparing tsvector results

2016-06-16 Thread David G. Johnston
Please do not top-post. ​On Thu, Jun 16, 2016 at 2:38 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thu, Jun 16, 2016 at 2:21 PM, Liza Sazonova wrote: > >> Hello, >> >> I'm trying to implement a keyword-based search on my database. >> >> I have some text input (Say, "The A or B

Re: [GENERAL] Comparing tsvector results

2016-06-16 Thread Liza Sazonova
Thank you! It seems like this function's not available in PostgreSQL 9.5 that I'm using I'm getting: "ERROR: function ​tsvector_to_array(unknown) does not exist". Do you know of any equivalent function in earlier releases? I was thinking of casting ts_vector into text, and then splitting the te

Re: [GENERAL] Comparing tsvector results

2016-06-16 Thread David G. Johnston
On Thu, Jun 16, 2016 at 2:21 PM, Liza Sazonova wrote: > Hello, > > I'm trying to implement a keyword-based search on my database. > > I have some text input (Say, "The A or B and C with D") and a list of > keywords ("B","X","Y"). I want to identify which keywords are present in > the text input.

[GENERAL] Comparing tsvector results

2016-06-16 Thread Liza Sazonova
Hello, I'm trying to implement a keyword-based search on my database. I have some text input (Say, "The A or B and C with D") and a list of keywords ("B","X","Y"). I want to identify which keywords are present in the text input. I also want to use a thesaurus to process the text input, since the