egdb3_12_9
.search
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
query_parse_phrases(phrase text)
Parameters
Name
Type
Mode
phrase
text
IN
Definition
SELECT search.distribute_phrase_sign(UNNEST) FROM (SELECT UNNEST(x), ROW_NUMBER() OVER () FROM regexp_matches($1, '(?:^|\s+)(?:((?:-|\+)?"[^"]+")|((?:-|\+)?[[:alnum:]]+''*[[:alnum:]]*))', 'g') x ) y WHERE UNNEST IS NOT NULL ORDER BY row_number