Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://github.com/cockroachdb/cockroach/issues/41288 below:

support tsvector, tsquery based full text search · Issue #41288 · cockroachdb/cockroach · GitHub

Postgres has some advanced text search types and features that Django uses that we we don't support --
https://www.postgresql.org/docs/10/functions-textsearch.html
https://www.postgresql.org/docs/10/datatype-textsearch.html

This includes the tsvector and regconfig types and operations on them.

• parsers (tokenizing)
• the rest of the token types supported by Postgres's default parser: tsearch: support all token types in text search parser #97669
• dictionaries (stemming and stopwords - made by parameterizing a template)
• templates (templates for dictionaries)
• configurations (pair of parser and dictionary)
• regconfig datatype
• regdictionary datatype
• tsvector datastructure
• tsquery datastructure
• to_tsvector
• to_tsquery
• phraseto_tsquery
• plainto_tsquery
• websearch_to_tsquery
• tsquery_phrase
• accelerated searches with @@
• GIN index on tsvectors
• weights
• ts_rank
• ts_rank_cd
• strip(tsvector)
• length(tsvector)
• setweight(tsvector)
• array_to_tsvector(text[])
• numnode(tsquery)
• querytree(tsquery)
• ts_delete(tsvector, text)
• ts_headline
• ts_rewrite
• tsvector_to_array(tsvector)
• jsonb_to_tsvector / json_to_tsvector ( sql: support jsonb_to_tsvector #109955)
• unnest(tsvector)
• inverted join on tsvectors

And SQL operators for tsvector:

• @@ (matching a tsvector and tsquery)
• tsvector || tsvector (concatenation of tsquery)
• tsquery || tsquery (OR 2 tsqueries)
• tsquery && tsquery (AND 2 tsqueries)
• tsquery <-> tsquery (followedby 2 tsqueries()
• !! tsquery (negate a tsquery)
• tsquery @> tsquery (contains)
• tsquery <@ tsquery (contained-by)

Jira issue: CRDB-5464
Epic: CRDB-22357

kocoten1992, dinedal, bikbah, fauno, lime008 and 28 more

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4