prorm API Reference
    Preparing search index...

    Function phraseToTsquery

    • Create a PostgreSQL phraseto_tsquery expression (for exact phrase matching) SQL: phraseto_tsquery(config, query)

      Parameters

      • query: string
      • Optionalconfig: string

      Returns { $phraseTsquery: { query: string; config: string } }

      import { phraseToTsquery } from 'orm';
      Article.findAll({
      where: {
      body: { [phraseToTsquery('database')]: true }
      }
      })
      // SQL: WHERE body @@ phraseto_tsquery('english', 'database')