Re: wrong number of arguments to function rank()

 > Looks like there should be one argument after the "matchinfo" for 
each > column in the table. So:

 >  SELECT rank(matchinfo(event_search_test), 1.0, 1.0) AS rank,
 > room_id...

Yes, I realised that nVal is the number of arguments passed to the 
function, so  according to nVal!=(1+nCol) I have to pass as many 
argument after matchinfo() as the number of columns.

This means that the documention is at least misleading, and also I was 
not able to make it work anyway

I'm using the example from the docs:

sqlite> CREATE VIRTUAL TABLE documents USING fts4(title, content);
sqlite> INSERT INTO documents VALUES ('title', 'content');
sqlite> SELECT quote(matchinfo(documents)) FROM documents WHERE title 
MATCH 'title';
X'0100000002000000010000000100000001000000000000000000000000000000'
sqlite> SELECT rank(matchinfo(documents), 1.0, 1.0) FROM documents WHERE 
title MATCH 'title';
Error: wrong number of arguments to function rank()


_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users