interesting, but I like '.' as path separator, it's url-friendly, and easy I used some simple `path TEXT CHECK (path ~ '^[\w.-]+$')` but now I regret it, because it's not as easy to index and optimize requests
2017-05-21 11:28 GMT+02:00 Manuel Kniep <rap...@adeven.com>: > > > > > Manuel Kniep > Danziger Str. 116 > 10405 Berlin > Am 20.05.2017 um 10:27 schrieb Cyril Auburtin <cyril.aubur...@gmail.com>: > > It could be useful to allow the `-` char in allowed LTREE label characters > (currently > a-zA-Z0-9_ https:// > <https://www.postgresql.org/docs/9.6/static/ltree.html>https:// > github.com/adjust/ltreewww.postgresql.org/docs/9.6/static/ltree.html) > > > There is a patched version here > https://github.com/adjust/ltree > > Which allows almost any char but uses '::' as label separator my it's an > inspiration to do your own patch. > > Manuel > > >
