Browse categories
PostgreSQL releases
- PostgreSQL 15 (dev)
- PostgreSQL 14 (beta3)
- PostgreSQL 13 (latest)
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10
- PostgreSQL 9.6
- PostgreSQL 9.5 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Contrib modules
Object Identifier Types
Progress reporting views
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Change history
- Bugfixes
References
Categories
See also

ltree

A contrib module providing the data type ltree

ltree is a contrib module providing the data type ltree for representing labels of data stored in a hierarchical tree-like structure.

ltree was added in PostgreSQL 7.3.

Change history

Work-in-progress

PostgreSQL 13 (1.2)
- marked as a trusted extension (commit eb67623c)
- support for binary I/O of ltree, lquery, and ltxtquery types (commit 949a9f04)
- fixes for NOT handling (commit 70dc4c50)
- ability to quantify non-'*' items to use a numeric range ({}) of matches (commit 70dc4c50)
PostgreSQL 9.6 (1.1)
- functions marked PARALLEL SAFE (commit 2910fc82)
PostgreSQL 8.4
- support for multibyte encoding added (commit 8eee65c9)
PostgreSQL 7.3
- added (commit 1dedbf2d)

Bugfixes

PostgreSQL 8.4
- Allow zero-dimensional (ie, empty) arrays in contrib/ltree operations (commit 29667c85; backpatched to PostgreSQL 8.3)

References

PostgreSQL documentation: ltree

Categories

See also

ltree (data type)