Skip to main content
Version: v2.x

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
Documentation Explorer
No Schema Available

_ancestor_any

GraphiQL
Query Variables
Request Headers
Documentation Explorer
No Schema Available

_matches

Match any label path containing the node Astronomy.

GraphiQL
Query Variables
Request Headers
Documentation Explorer
No Schema Available

_matches_any

Select ltree paths matching any lquery regex in an array

GraphiQL
Query Variables
Request Headers
Documentation Explorer
No Schema Available

_descendant

GraphiQL
Query Variables
Request Headers
Documentation Explorer
No Schema Available

_descendant_any

GraphiQL
Query Variables
Request Headers
Documentation Explorer
No Schema Available

_matches_fulltext

Match any label path containing a node containing the substring Astro.

GraphiQL
Query Variables
Request Headers
Documentation Explorer
No Schema Available