> > Read the documentation carefully: > http://www.sqlite.org/fts3.html#matchinfo. Right the first paragraph: > > The matchinfo function returns a blob value. If it is used within a > query that does not use the full-text index (a "query by rowid" or > "linear scan"), then the blob is zero bytes in size. Otherwise, the > blob consists of zero or more 32-bit unsigned integers in machine > byte-order. > > What part of this paragraph makes you believe that if you print the > result of matchinfo as text you will see something meaningful? >
The part where it shows output in the comments of the example that, according to common conventions used in documentation, would indicate it is the output of the function (which it is, just not the user-viewable output). Plenty of languages (javascript, ruby, python, etc, etc, etc) pretty-print native objects when they are to be represented as text. What about that paragraph indicates that the sqlite3 cli doesn't know how to pretty-print understand its own native types? AJ ONeal _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
