An AI application needs full-text search AND vector similarity in the same query. Which PostgreSQL feature enables hybrid search combining both?
- A Full-text search only via tsvector
- B Vector search only via pgvector
- C Hybrid query combining tsvector full-text ranking with pgvector similarity using RRF or weighted score (correct answer)
- D Not possible in PostgreSQL
Shortcut: Hybrid search combines pg full-text search (tsvector/tsrank) and pgvector similarity (cosine/L2) in a single query, using Reciprocal Rank Fusion (RRF) or weighted scoring to merge results.