On Tue, Aug 30, 2011 at 10:01 AM, <sqlite-users-boun...@sqlite.org> wrote:
> The attached message matched the sqlite-users mailing list's content > filtering rules and was prevented from being forwarded on to the list > membership. > ---------- Forwarded message ---------- > From: fbu...@web.de > To: sqlite-users@sqlite.org > Date: Tue, 30 Aug 2011 16:01:24 +0200 (CEST) > Subject: Bug in using overloaded functions for virtual tables? > > SELECT DISTINCT offsets(pages) FROM pages; > -or- > SELECT offsets(pages),count(*) FROM pages GROUP BY 1 > > => error message: unable to use function offsets in the requested context > > Is this is a bug or a restriction, which is not documented? If this is a > restriction it should be considered as a feature request to allow using > virtual table functions in queries with the DISTINCT keyword or the GROUP BY > clause. Otherwise the bug should be fixed :-) > The offsets() function of FTS4 gives you the locations in each record of where your matching search terms are located. But you didn't specify any search terms - there is no MATCH operator in the WHERE clause. So what where you hoping to get back with these queries? > > Thanks. > > Schon gehört? WEB.DE hat einen genialen Phishing-Filter in die > Toolbar eingebaut! > *http://produkte.web.de/go/toolbar*<http://produkte.web.de/go/toolbar> > > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users