Highlighting
Highlighting is an expensive process and can slow down query times.
We recommend passing a LIMIT
to any query where paradedb.snippet
is called to restrict the
number of snippets that need to be generated.
Highlighting is not supported for paradedb.fuzzy_term
and paradedb.match
.
Highlighting refers to the practice of visually emphasizing the portions of a document that match a user’s
search query. Highlighted snippets of text are by default wrapped in <b></b>
tags. This can
be modified with the start_tag
and end_tag
arguments.
Basic Usage
paradedb.snippet(<column>)
can be added to any query where an @@@
operator is present.
The following query generates highlighted snippets against the description
field.
The leading indicator around the highlighted region.
The trailing indicator around the highlighted region.
Max number of characters for a highlighted fragment.
By default, <b></b>
encloses the snippet. This can be configured with start_tag
and end_tag
:
Byte Offsets
paradedb.snippet_positions(<column>)
returns the byte offsets in the original text where the snippets would appear. It returns an array of
tuples, where the the first element of the tuple is the byte index of the first byte of the highlighted region, and the second element is the byte index after the last byte of the region.