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? I would prefer not to store all offsets from all results in order to keep memory requirements low. Thanks for any suggestion, Ralf ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
