wltree
wltree copied to clipboard
adjust
adjust's patched version of postgres ltree
trafficstars
adjust ltree implementation
This is adevens patched version of Postgres ltree module.
Original written by Teodor Sigaev ([email protected]) and Oleg Bartunov ([email protected])
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:
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.
adjust