On Mon, 29 Nov 2010, AI Rumman wrote:
Oh! Actualy it is:
select replace('Dhaka University of Bangladesh:*', ' ',':* & ');
No space at start.
So, what are actual problems with full text ? I mostly interesting with
server crush. We need test data, test query and error message.
On Mon, Nov
Just a general note re the subject, I've also had troubles with
postgres being unable to optimize a query with OR. The work-around,
although a bit messy, was to use a UNION-query instead.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscr
Oh! Actualy it is:
select replace('Dhaka University of Bangladesh:*', ' ',':* & ');
No space at start.
On Mon, Nov 29, 2010 at 6:37 PM, Oleg Bartunov wrote:
> What does replace(' Dhaka University of Bangladesh:*', ' ',':* & ') means ?
> I see it produces something wrong for to_tsquery:
>
> test=
What does replace(' Dhaka University of Bangladesh:*', ' ',':* & ') means ?
I see it produces something wrong for to_tsquery:
test=# select replace(' Dhaka University of Bangladesh:*', ' ',':* & ');
replace
---
:* & Dhaka:*
explain
SELECT crmentity.crmid, crmentity.setype, crmentity.modifiedtime,
activity.subject,case when ( users.user_name not like '') then
users.user_name else groups.groupname end as user_name, activity.date_start
FROM crmentity INNER JOIN activity ON crmentity.crmid = activity.activityid
and crment
