Faceted Search

Category-aware retrieval with filtering.

Faceted Search Query

Copy
-- Faceted search with category filtering
SELECT * FROM faceted_search(
    'documents',
    embed_text('query'),
    '{"category": "AI", "language": "en"}'::jsonb,
    10
);

Multiple Facets

Filter by multiple categories:

Copy
-- Multi-facet search
SELECT * FROM faceted_search(
    'documents',
    embed_text('machine learning'),
    '{
        "category": ["AI", "ML"],
        "year": [2023, 2024],
        "status": "published"
    }'::jsonb,
    20
);

Facet Aggregation

Get facet counts:

Copy
-- Get facet distribution
SELECT facet_counts(
    'documents',
    '{"category": "AI"}'::jsonb,
    ARRAY['year', 'language']
) AS facet_stats;

Learn More

For detailed documentation on faceted search, facet hierarchies, filtering strategies, and performance optimization, visit:

Faceted Search Documentation

Related Topics

• Hybrid Search - Combined search strategies
• Temporal Search - Time-based filtering