Hi, I'm trying to use tsearch2 for the first time and I'm having a
problem setting up a query
If I execute
SELECT * from test_table where ts_desc @@ to_tsquery ('hello&world');
it works, but I'm having the problem that the string used for the query
is not 'hello&world' but 'hello world', Moreove
On Mon, 7 May 2007, Ottavio Campana wrote:
Hi, I'm trying to use tsearch2 for the first time and I'm having a
problem setting up a query
If I execute
SELECT * from test_table where ts_desc @@ to_tsquery ('hello&world');
it works, but I'm having the problem that the string used for the query
i
On Mon, May 07, 2007 at 05:31:02PM -0700, Ottavio Campana wrote:
> Hi, I'm trying to use tsearch2 for the first time and I'm having a
> problem setting up a query
>
> If I execute
>
> SELECT * from test_table where ts_desc @@ to_tsquery ('hello&world');
>
> it works, but I'm having the problem t
Magnus Hagander wrote:
> On Mon, May 07, 2007 at 05:31:02PM -0700, Ottavio Campana wrote:
>> Hi, I'm trying to use tsearch2 for the first time and I'm having a
>> problem setting up a query
>>
>> If I execute
>>
>> SELECT * from test_table where ts_desc @@ to_tsquery ('hello&world');
>>
>> it works
Ottavio Campana wrote:
> Magnus Hagander wrote:
>> On Mon, May 07, 2007 at 05:31:02PM -0700, Ottavio Campana wrote:
>>> Hi, I'm trying to use tsearch2 for the first time and I'm having a
>>> problem setting up a query
>>>
>>> If I execute
>>>
>>> SELECT * from test_table where ts_desc @@ to_tsquery
Magnus Hagander wrote:
>> I'm using 8.1.8 and I don't find plainto_tsquery in tsearch2.sql
>>
>> What can I do?
>
> Yeah, you need 8.2 for that function. I don't think anybody has tried
> backpatching it, but if you want to you can look at the code in 8.2 and
> see if you can backpatch it yourself