mORMot Open Source

edwinsn

Member

Registered: 2010-07-02

Posts: 1,218

How to use 'notindexed' directive to exclude column from FTS4?

Hello ab,

Sqlite FTS4 supports the 'notindexed' directive for excluding a specific column from indexing, when creating the table, for example:

CREATE VIRTUAL TABLE t USING FTS4(uuid, document, notindexed=uuid);

Some details here: https://stackoverflow.com/a/18531449/133516

How to achieve this for TSQLRecordFTS4Unicode61?

Thanks.

---

Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,669

Website

Re: How to use 'notindexed' directive to exclude column from FTS4?

You have to create the table by hand via SQL.

edwinsn

Member

Registered: 2010-07-02

Posts: 1,218

Re: How to use 'notindexed' directive to exclude column from FTS4?

Oh I see. Thank you ab.

---

Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.