From: | Liza Sazonova <liza(at)getpitstop(dot)io> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Comparing tsvector results |
Date: | 2016-06-16 18:21:13 |
Message-ID: | CAE49Aj6i6OMOrqAezSa78UHpZ0Ug-YDC8Ex4NC+V5Hy+cz6qbg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 keywords have synonyms (for example, "The A : X").
As far as I understand, the only way for me to process text input with a
thesaurus would be to use tsvector / tsquery; or at least this is the
fastest way.
Is it possible to retrieve the tsvector from the text input, then retrieve
the tsvector from the keyword list, and identify which words are present in
both?
Thank you!
From | Date | Subject | |
---|---|---|---|
Next Message | Durgamahesh Manne | 2016-06-16 18:28:35 | Re: Re: regarding schema only migration from sqlserver to postgres with runmtk.sh |
Previous Message | Durgamahesh Manne | 2016-06-16 18:13:54 | Re: Re: regarding schema only migration from sqlserver to postgres with runmtk.sh |