psql
, run the following commands to create and inspect
this table.
Expected Response
search_idx
on this table. A BM25 index is a covering index, which means that multiple columns can be included in the same index.
COUNT
, GROUP BY
, or ORDER BY
as part of a full text query should be added to the index for faster
performance.key_field
option. Every BM25 index needs a key_field
,
which should be the name of a column that will function as a row’s unique
identifier within the index. Additionally, the key_field
must be the first field
in the list of columns. See choosing a key field for more details.description
matches running shoes
where rating
is greater than 2
.
Expected Response
|||
is ParadeDB’s custom match disjunction operator, which means “find me all documents containing
running OR shoes
.
If we want all documents containing running AND shoes
, we can use ParadeDB’s &&&
match conjunction operator.
Expected Response
paradedb.score
.
Expected Response
paradedb.snippet
.
Expected Response