Breaking News: Grepper is joining You.com. Read the official announcement!

postgres full text search example

Disturbed Donkey answered on March 19, 2021 Popularity 10/10 Helpfulness 3/10

answer postgres full text search example

postgres full text search example

Comment

SELECT document_id, document_text FROM documents  
WHERE document_tokens @@ to_tsquery('jump & quick');

Popularity 10/10 Helpfulness 3/10 Language sql

Source: www.compose.com

Tags: full-text-search sql

Link to this answer
Share Copy Link

Contributed on Nov 18 2021

Disturbed Donkey

0 Answers Avg Quality 2/10

Closely Related Answers

postgresql full text search

Comment

Full Text Searching (or just text search) provides the capability to 
identify natural-language documents that satisfy a query, and optionally
to sort them by relevance to the query. The most common type of search is
to find all documents containing given query terms and return them in
order of their similarity to the query. Notions of query and similarity 
are very flexible and depend on the specific application. The simplest
search considers query as a set of words and similarity as the frequency
of query words in the document.

Popularity 10/10 Helpfulness 3/10 Language sql

Source: www.postgresql.org

Tags: full-text-search full

Link to this answer
Share Copy Link