prorm API Reference
    Preparing search index...

    Function plainToTsquery

    • Create a PostgreSQL plainto_tsquery expression (for phrase searching) SQL: plainto_tsquery(config, query)

      Parameters

      • query: string
      • Optionalconfig: string

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

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