Functions / Text Search Functions And Operators

querytree

Produces a representation of the indexable portion of a tsquery.

Reading PG 18current·documented in 20 of 27 versions, 8.3 to 20

Signatures & examples

querytree ( tsquery ) → text

Produces a representation of the indexable portion of a tsquery. A result that is empty or just T indicates a non-indexable query.

querytree('foo & ! bar'::tsquery) → 'foo'

Version history 2

Definition snapshot: b7bd9cda · English manual source