At 14:03 +0100 1/8/03, Walter Procopio wrote:
>Hi,
>
>I have installed mysql max 4.0.7 gamma on a Suse (ver. 8.0 professional)
>linux server. I have tried many full text queries and I had only a problem
>with a query like this:
>
>SELECT count(a.rsori) pippo
>FROM ecoras a, ecotxt b
>WHERE MATCH ( b.rstxt ) AGAINST ( '-linux' IN BOOLEAN MODE )
>AND a.rsori = b.rsori
>AND a.rscod = b.rscod;
>
>If I use only the minus operator I have not a valid resultset.
Isn't that the same as asking for records that don't match anything?
> If I use the
>minus operator with another one I have a reultset.
>For example:
>
>SELECT count(a.rsori) pippo
>FROM ecoras a, ecotxt b
>WHERE MATCH ( b.rstxt ) AGAINST ( '+linux -windows' IN BOOLEAN MODE )
>AND a.rsori = b.rsori
>AND a.rscod = b.rscod;
>
>Is it a full text limit?
>
>Thanks
>Walter Procopio
