Hierarchical tree-like structures in PostgreSQL databases
ltree
extension provides support for hierarchical tree-like structures in PostgreSQL databases. It’s particularly useful for storing and querying hierarchical data such as organizational structures, file systems, or category trees.
Your Nile database arrives with the ltree
extension already enabled.
<@
: Is left argument a descendant of right (or equal)?@>
: Is left argument an ancestor of right (or equal)?~
: Does ltree match lquery??
: Does ltree match ltxtquery?||
: Concatenate ltree pathssubpath(ltree, offset, len)
: Get subpath of ltreenlevel(ltree)
: Return number of labels in pathindex(ltree, ltree)
: Return position of second ltree in firsttext2ltree(text)
: Cast text to ltreeltree2text(ltree)
: Cast ltree to text