Ralf Junker <[EMAIL PROTECTED]> wrote: > I want to use this SQL query to retrieve the offsets information for a single > FTS1 result: > > select rowid, offsets (x) from x where Content match 'search' and rowid = 1; > > Surprisingly, the query fails due to > > Error 1: unable to use function MATCH in the requested context. > > It seems that MATCH can not be combined with other conditions in a WHERE > clause. I then tried the query as a subquery, but this also produces the > same error. > > Is there a workaround?
Make the second term: +rowid=1 That is to say, put a unary "+" in front of the "rowid". The behavior you have discovered is a well-known issue to the developers. I'm hoping to fix it in a future version. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
