Marco You might want to send this to the JBASE group - not the U2 group! They are completely different products.
You can find the jBase group on Google Groups: http://groups.google.com/group/jBASE Email: [EMAIL PROTECTED] Brian > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Marco Manyevere > Sent: 27 July 2007 11:49 > To: [email protected] > Subject: [U2] [jBASE] SELECT operator precedence > > I expected the following three SELECT statements to be > equivalent but they dont seem to be: > > >CLEARSELECT > [528] List '0' cleared. > jsh rbk ~ -->SELECT > ACCOUNT WITH CATEGORY EQ 1000 OR GE 1002 AND LE 9999 > 173218 Records selected > >CLEARSELECT > [528] List '0' cleared. > jsh rbk ~ -->SELECT ACCOUNT WITH CATEGORY GE 1002 AND LE 9999 > OR EQ 1000 102160 Records selected > >CLEARSELECT > [528] > List '0' cleared. > jsh rbk ~ -->SELECT ACCOUNT WITH CATEGORY (GE 1002 AND LE > 9999) OR EQ 1000 > 173218 Records selected > > The second select seems to be > ignoring the OR EQ 1000 as it is returning the same number of > records with: > >CLEARSELECT > [528] List '0' cleared. > jsh rbk ~ -->SELECT ACCOUNT WITH CATEGORY GE 1002 AND LE 9999 > 102160 Records selected > > I expect the brackets around (GE > 1002 AND LE 9999) to be superfluous (only required to make > the syntax clearer) but they seem to be having an impact on > the number of records selected. Can someone please clarify. > > Regards, Marco. > ___________________________________________________________ > Yahoo! Answers - > Got a question? Someone out there knows the answer. Try it now. > http://uk.answers.yahoo.com/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
