Hi,
Thanks for the reply. It worked.
But I also fixed the original ts_query as follows which gives the exact
result
SELECT * from question
where
weighted_tsv @@ to_tsquery('Hur&ofta');
Thank you .
regards
Kiran
On Mon, Sep 19, 2016 at 11:21 AM, Oleg Bartunov wrote:
> On Mon, Sep 19, 2016 at
On Mon, Sep 19, 2016 at 4:19 AM, Oleg Bartunov wrote:
> On Mon, Sep 19, 2016 at 3:46 AM, Kiran wrote:
>> Dear All,
>>
>> I have a ts_vector column in question table called weighted_tsv.
>> I am trying to search using ts_query as follows
>>
>> SELECT *
>>
>> FROM question
>>
>> WHERE weighted_tsv
On Mon, Sep 19, 2016 at 3:46 AM, Kiran wrote:
> Dear All,
>
> I have a ts_vector column in question table called weighted_tsv.
> I am trying to search using ts_query as follows
>
> SELECT *
>
> FROM question
>
> WHERE weighted_tsv @@ to_tsquery('Hur ofta');
you should use to_tsquery('Hur & ofta')
Dear All,
I have a ts_vector column in question table called *weighted_tsv*.
I am trying to search using ts_query as follows
SELECT *
FROM question
WHERE weighted_tsv @@ to_tsquery('Hur ofta');
*But the query results in an error as follows:*
ERROR: function ts_query(unknown) does not exist
