Package Exports
- pg-tsquery
- pg-tsquery/index.js
This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (pg-tsquery) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.
Readme
Text-Search parser for PostgreSQL
Why?
Using pg's to_tsquery directly with user input can throw errors. plainto_tsquery sanitizes the user input, but it's very limited (it just puts an and between words), websearch_to_tsquery extends this behavior a little further only between double-quotes, with followedBy operator and negations.
This module allows customizable text-search operators: and, or, followedBy, not, prefix, parentheses, quoted text (same behavior than websearch_to_tsquery).
See the options defaults values
usage
const tsquery = require('pg-tsquery')(/* options can be passed to override the defaults */);
pool.query('SELECT * FROM tabby WHERE to_tsvector(col) @@ to_tsquery($1)', [tsquery(str)]);
// or get a reusable instance
const {Tsquery} = require('pg-tsquery');
const parser = new Tsquery(/* options can be passed to override the defaults */);
// then process your input with parser.parse(str).toString()| inputs | output |
|---|---|
foo bar |
foo&bar |
foo -bar, foo !bar, foo + !bar |
foo&!bar |
foo bar,bip, foo+bar | bip |
foo&bar|bip |
foo (bar,bip), foo+(bar|bip) |
foo&(bar|bip) |
foo>bar>bip |
foo<->bar<->bip |
foo*,bar* bana:* |
foo:*|bar:*&bana:* |
Demo
Support
Please consider reporting issues and trying to create a pull request as well