wltree 0.2.0
- This Release
- wltree 0.2.0
- Date
- Status
- Stable
- Abstract
- This is adevens patched version of Postgres ltree module
- Description
- This is adevens patched version of Postgres ltree module
- Released By
- adjustgmbh
- License
- PostgreSQL
- Resources
- Special Files
Extensions
- wltree 0.2.0
- This is adevens patched version of Postgres ltree module
Documentation
- README.rename
- README.rename
README
adjust ltree implementation
This is adevens patched version of Postgres ltree module.
Original written by Teodor Sigaev (teodor@sigaev.ru) and Oleg Bartunov (oleg@sai.msu.su)
It's different in using :: instead of . as label separator.
And it allows to have special characters like { } ! * in ltree labels.
You can match those label in ltree queries by escaping these characters:
SQL
SELECT '!foo::{bar}::baz%'::ltree ~ '\!foo::\{bar\}::baz\%';
Unsupported features
- Full-text queries a.k.a. ltxtquery currently does not support usage of escaped characters.