Some query help!!

skalyanaraman · Post by **skalyanaraman** » Wed Apr 10, 2002 7:59 pm

Hi,
There are a couple of kind of queries which look tough (for me). Could you please help!

1. I am looking to find
a field which has atleast one of ('George','Bush','america') within 50 characters of atleast one of ('Deanna','tea','past','future').
Is the question clear? I want the field to have atleast one word from the first list and the words found should be within 50 characters of atleast one word from the second list.

How do we write a query for this?

thanks!!

Post by **mark** » Wed Apr 10, 2002 10:10 pm

('George','Bush','america') ('Deanna','tea','past','future') w/50

you'll also need to have alpopostproc on.

skalyanaraman · Post by **skalyanaraman** » Wed Apr 10, 2002 11:38 pm

Thanks for the help.
Can I ask why I need to have alpostproc on?
also, I am running this query at the tsql prompt. Can i set alpostproc there? I cannot, I think.. also, is it a default when I run at the tsql prompt?

thanks

skalyanaraman · Post by **skalyanaraman** » Wed Apr 10, 2002 11:47 pm

Oh, also one more info.
couple of the terms in the second list are wildcard. I know that wildcard terms inside (,,) for or search won't go well. So, I tried to put a @0 kind of a search. So, is the following possible, and get me what I want?

select DOCID from tbldoc where FIELD1 like 'w/50 ''George Bush America @0'' ''Deanna Tea Past* Future* @0''';

I put the double singlequotes for escaping them.

am I just crazy or is this going to work?

thanks

Post by **mark** » Thu Apr 11, 2002 9:55 am

Sorry, I got carried away with cut-and-paste in #2. It should be
(George,Bush,america) (Deanna,tea,past,future) w/50
The w/ operator requires postprocessing. alpostproc is default on in tsql, default off in vortex.

Intersects (@) apply to all non required and non excluded terms within the query. For that query you could use:
w/50 +(George,Bush,America) Deanna Tea Past* Future* @0