dbbase.column_types.WriteOnlyColumn.match

WriteOnlyColumn.match(other, **kwargs)

Implements a database-specific ‘match’ operator.

match() attempts to resolve to a MATCH-like function or operator provided by the backend. Examples include:

  • PostgreSQL - renders x @@ to_tsquery(y)

  • MySQL - renders MATCH (x) AGAINST (y IN BOOLEAN MODE)

  • Oracle - renders CONTAINS(x, y)

  • other backends may provide special implementations.

  • Backends without any special implementation will emit the operator as “MATCH”. This is compatible with SQLite, for example.