tsvector

CREATE TABLE articles (
    id SERIAL PRIMARY KEY,
    title TEXT,
    content TEXT,
    search_vector TSVECTOR
);

UPDATE articles SET search_vector = to_tsvector(title || ' ' || content);

SELECT * FROM articles WHERE search_vector @@ to_tsquery('search & term');

-- 创建表
CREATE TABLE products (
    id SERIAL PRIMARY KEY,
    name TEXT,
    description TEXT,
    search_vector TSVECTOR
);

-- 插入数据
INSERT INTO products (name, description) VALUES ('Laptop', 'A portable computer for work and entertainment.');
INSERT INTO products (name, description) VALUES ('Smartphone', 'A mobile phone with advanced features.');

-- 更新 search_vector 列
UPDATE products SET search_vector = to_tsvector(name || ' ' || description);

-- 执行全文搜索查询
SELECT * FROM products WHERE search_vector @@ to_tsquery('laptop & computer');