CRDB compatibility with Postgres LTREE data type

[florence-crl]

Feature requested in forum

Is your feature request related to a problem? Please describe.

Describe the solution you'd like CRDB compatibility with Postgres LTREE data type as described here

Describe alternatives you've considered

Additional context

root@localhost:26257/bank> CREATE TABLE test (path ltree);
invalid syntax: statement ignored: at or near "ltree": syntax error: type does not exist
DETAIL: source SQL:
CREATE TABLE test (path ltree)
                        ^

Epic: CRDB-148

Jira issue: CRDB-5214

[jlgerber]

Ltree has proven to be a really good way of materializing hierarchies for us.

For example, we are in M&E, and have a number of asset management systems that utilize ltree to associate assets with a project level (show.sequence.shot). Using the ltree extension, we are able to efficiently look up all the assets in a particular show, or sequence in the show, or shot,etc, without resorting to recursive joins, or the more cumbersome solutions (found for instance in Joe Celko's Trees and Hierarchies bool)

[chickahoona]

I myself would be interested to see this too. With Psono I'd like to explore alternative databases that allow a georedundant setup more easily and CockroachDB is sadly not possible as ltree doesn't work :(

[cbollerud]

Is Ltree still under consideration? It has been a useful feature with several companies to quickly select on a subset of a hierarchy.

[alen-z]

Bumping this as a deciding factor to move to CRDB.

[koudelka]

Also interested in this!

[alen-z]

Bump as it’s a critical feature for us to consider CRDB. We love it and would like to use it. Any plans here?