The Hermit Hacker wrote:
>
> okay, can someone make the following changes to the source code, so that
> the search avoids using the index ... this will at least give a temporary
> fix until our LIKE optimizer is fixed:
>
> SELECT ndict.url_id,ndict.intag
> FROM ndict,url
> WHERE ndict.word_id=1971739852
> AND url.rec_id=ndict.url_id
> AND ( (url.url || ' ') LIKE 'http://www.postgresql.org/% ');
I don't think that this is the best solution to fix search for buggy
LIKE optimizer then to fix search back for fixed optimizer.
______________
If you want to unsubscribe send "unsubscribe udmsearch"
to [EMAIL PROTECTED]