• Browse categories
• PostgreSQL releases
  • PostgreSQL 14 (dev)
  • PostgreSQL 13 (latest)
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6
  • PostgreSQL 9.5
  • PostgreSQL 9.4 (EOL)

Useful articles

Useful links

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 7.3
  • added (commit 1dedbf2d)

References

Categories

See also