Re: Allowing dash character in LTREE

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 <rapimo(at)adeven(dot)com>:

>
>
>
>
> Manuel Kniep
> Danziger Str. 116
> 10405 Berlin
> Am 20.05.2017 um 10:27 schrieb Cyril Auburtin <cyril(dot)auburtin(at)gmail(dot)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
>
>
>