Skip to content
ParticleDB
Release candidateParticleDB 1.1.19-rc.17 is not yet GA or ready for production data.Release status →

Search text

Match text with patterns and supported text-search functions.

CREATE TABLE docs_text (id BIGINT PRIMARY KEY, title TEXT);
INSERT INTO docs_text VALUES (1, 'Database guide'), (2, 'API reference');
SELECT id, title FROM docs_text WHERE title ILIKE '%database%';
SELECT to_tsvector('english', 'The quick fox') @@ to_tsquery('english', 'fox') AS matches;

Pattern matching and word search have different semantics. Neither is vector similarity search. Test tokenization, language handling and index use on your own data. A parser accepting an index declaration does not prove that a particular query uses that index.

SQL reference · Application guide · Troubleshooting