SQLite Forum

Can I select the FTS4 hidden column?
Login

Can I select the FTS4 hidden column?

(1) By Deon Brewis (deonb) on 2021-02-06 06:29:59 [link] [source]

Is there a way I can read a FTS4 hidden column? (the table-named column).

I know I can use snippet(), but that only works if I have something that MATCH. A straight select over it just returns null.

Reason is, I would like to run a Regular Expression over that column in order to search for something in a way not supported by MATCH.

Or is that column entirely virtual, and only exist at the time of query from the other columns in the table?

The documentation calls it "an automatically-generated column", rather than a virtual column, hence my wondering if there is actual data there that I can use.

(2) By Dan Kennedy (dan) on 2021-02-08 06:01:07 in reply to 1 [source]

There's no useful data for users in that column. It's an opaque handle only useful to fts4 internals.

Dan.