Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

RFC: Interest in adding ltree support? #101

Open
bf4 opened this issue Mar 26, 2024 · 0 comments
Open

RFC: Interest in adding ltree support? #101

bf4 opened this issue Mar 26, 2024 · 0 comments

Comments

@bf4
Copy link
Contributor

bf4 commented Mar 26, 2024

https://www.postgresql.org/docs/current/ltree.html

This module implements a data type ltree for representing labels of data stored in a hierarchical tree-like structure. Extensive facilities for searching through label trees are provided.

A label is a sequence of alphanumeric characters, underscores, and hyphens. Valid alphanumeric character ranges are dependent on the database locale. For example, in C locale, the characters A-Za-z0-9_- are allowed. Labels must be no more than 1000 characters long.

Examples: 42, Personal_Services

A label path is a sequence of zero or more labels separated by dots, for example L1.L2.L3, representing a path from the root of a hierarchical tree to a particular node. The length of a label path cannot exceed 65535 labels.

Example: Top.Countries.Europe.Russia

and see https://patshaughnessy.net/2017/12/13/saving-a-tree-in-postgres-using-ltree

perhaps adapt https://github.com/cfabianski/ltree_hierarchy

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant