Postgres: Filter by Hierarchical ltree Data
Introduction
Comparison operators on columns with ltree, lquery or ltxtquery types are supported.
Please submit a feature request via GitHub if you want support for more functions.
For more details on ltree operators and Postgres equivalents, refer to the
API reference.
_ancestor
Select ancestors of an ltree argument
GraphiQL
Query Variables
_ancestor_any
GraphiQL
Query Variables
_matches
Match any label path containing the node Astronomy.
GraphiQL
Query Variables
_matches_any
Select ltree paths matching any lquery regex in an array
GraphiQL
Query Variables
_descendant
GraphiQL
Query Variables
_descendant_any
GraphiQL
Query Variables
_matches_fulltext
Match any label path containing a node containing the substring Astro.
GraphiQL
Query Variables