/
sonne
/
Task-RatsAD-31.group
Обзор
Документация
Войти
/
sonne
/
Task-RatsAD-31.group
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
test_queries_examples.sql
34 строки
1 KB
arseon21
Add SQL
24 июн 2025, 20:24
24 июн 2025, 20:24
4416e94
Код
Авторство
О чём код?
\c fuzzy_search_lab; -- 1. LIKE EXPLAIN ANALYZE SELECT * FROM products WHERE brand LIKE 'ТехноКорп%'; -- 2. ILIKE EXPLAIN ANALYZE SELECT * FROM products WHERE LOWER(name) LIKE 'профессиональный%'; -- 3. pg_trgm EXPLAIN ANALYZE SELECT *, similarity(name, 'profesional synthesizer') AS sim FROM products WHERE name % 'profesional synthesizer' ORDER BY sim DESC LIMIT 10; -- 4. Levenshtein distance EXPLAIN ANALYZE SELECT *, levenshtein(name, 'profesional synthesizer') AS distance FROM products WHERE levenshtein(name, 'profesional synthesizer') <= 3 ORDER BY distance LIMIT 10; -- 5. Soundex EXPLAIN ANALYZE SELECT * FROM products WHERE soundex(name) = soundex('professional'); -- 6. Full-Text Search (FTS) EXPLAIN ANALYZE SELECT *, ts_rank(search_vector, query) AS rank FROM products, plainto_tsquery('english', 'professional synthesizer') query WHERE search_vector @@ query ORDER BY rank DESC LIMIT 10; -- 7. Similarity из pg_trgm EXPLAIN ANALYZE SELECT *, similarity(name, 'synthesizer') FROM products ORDER BY similarity(name, 'synthesizer') DESC LIMIT 5;