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
Request Headers
No Schema Available
_ancestor_any
GraphiQL
Query Variables
Request Headers
No Schema Available
_matches
Match any label path containing the node Astronomy
.
GraphiQL
Query Variables
Request Headers
No Schema Available
_matches_any
Select ltree paths matching any lquery regex in an array
GraphiQL
Query Variables
Request Headers
No Schema Available
_descendant
GraphiQL
Query Variables
Request Headers
No Schema Available
_descendant_any
GraphiQL
Query Variables
Request Headers
No Schema Available
_matches_fulltext
Match any label path containing a node containing the substring Astro
.
GraphiQL
Query Variables
Request Headers
No Schema Available