Skip to content
ClapDB ClapDB Docs

Full text Query

ClapDB supports searching the entire text of a Document. This Document type is quite different from usual databases; it’s more similar to a document in Elastic Search.

how to use full text query

Data Type

ClapDB provides a document type to enable full text search capabilities.

SQL API

  • like
  • ilike
  • regexp_like

PostgreSQL Full Text API

not supported by now, and will be supported in the future release.

  • tsvector
  • tsquery

Elastic Search API

ClapDB also supports Elastic Search API for full text query.(must with ClapDB Enterprise Edition)

You can use Elastic Query DSL

such as

GET /_search
{
  "query": {
    "query_string": {
      "query": "(new york city) OR (big apple)",
    }
  }
}