Thread: Results in ERROR: syntax error in tsquery:

Results in ERROR: syntax error in tsquery:

From
Kiran
Date:
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

LINE 1: ...* from question where weighted_tsv @@ ts_query('...

HINT:  No function matches the given name and argument types. You might need to add explicit type casts.


What is the reason I am getting this error I am not able to figure it out.

It would be of great help if anyone point me into right direction.


Thanks

Kiran




Re: Results in ERROR: syntax error in tsquery:

From
Oleg Bartunov
Date:
On Mon, Sep 19, 2016 at 3:46 AM, Kiran <bangalore.kiran@gmail.com> 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') ! Read
https://www.postgresql.org/docs/9.5/static/datatype-textsearch.html

>
>
> But the query results in an error as follows:
>
> ERROR:  function ts_query(unknown) does not exist
>
> LINE 1: ...* from question where weighted_tsv @@ ts_query('...
>
> HINT:  No function matches the given name and argument types. You might need
> to add explicit type casts.
>
>
> What is the reason I am getting this error I am not able to figure it out.
>
> It would be of great help if anyone point me into right direction.
>
>
> Thanks
>
> Kiran
>
>
>
>


Re: Results in ERROR: syntax error in tsquery:

From
Oleg Bartunov
Date:
On Mon, Sep 19, 2016 at 4:19 AM, Oleg Bartunov <obartunov@gmail.com> wrote:
> On Mon, Sep 19, 2016 at 3:46 AM, Kiran <bangalore.kiran@gmail.com> 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') ! Read
> https://www.postgresql.org/docs/9.5/static/datatype-textsearch.html

or use plainto_tsquery('Hur ofta')

>
>>
>>
>> But the query results in an error as follows:
>>
>> ERROR:  function ts_query(unknown) does not exist
>>
>> LINE 1: ...* from question where weighted_tsv @@ ts_query('...
>>
>> HINT:  No function matches the given name and argument types. You might need
>> to add explicit type casts.
>>
>>
>> What is the reason I am getting this error I am not able to figure it out.
>>
>> It would be of great help if anyone point me into right direction.
>>
>>
>> Thanks
>>
>> Kiran
>>
>>
>>
>>


Re: Results in ERROR: syntax error in tsquery:

From
Kiran
Date:
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 <obartunov@gmail.com> wrote:
On Mon, Sep 19, 2016 at 4:19 AM, Oleg Bartunov <obartunov@gmail.com> wrote:
> On Mon, Sep 19, 2016 at 3:46 AM, Kiran <bangalore.kiran@gmail.com> 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') ! Read
> https://www.postgresql.org/docs/9.5/static/datatype-textsearch.html

or use plainto_tsquery('Hur ofta')

>
>>
>>
>> But the query results in an error as follows:
>>
>> ERROR:  function ts_query(unknown) does not exist
>>
>> LINE 1: ...* from question where weighted_tsv @@ ts_query('...
>>
>> HINT:  No function matches the given name and argument types. You might need
>> to add explicit type casts.
>>
>>
>> What is the reason I am getting this error I am not able to figure it out.
>>
>> It would be of great help if anyone point me into right direction.
>>
>>
>> Thanks
>>
>> Kiran
>>
>>
>>
>>