On Tue, 22 Jan 2008 14:19:10 -0800, Scott Hess wrote > Hmm. I think the current behaviour is because the obvious result for > this query would be the set of all documents with the documents > matching each of the negated terms removed.
I disagree that this is the obvious result. Searching for empty string yields no results, so adding a constraint on top of that should also yield no results. But if searching for empty string yielded all rows, I would agree with you that it is the obvious result. > In the current system, calculating the set of all documents isn't > convenient, so since this couldn't be supported, it's an error. Then how does "select * from my_fts3_table" work? -- Andy Goth | <[EMAIL PROTECTED]> | http://andy.junkdrome.org/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------