Re: [HACKERS] Allowing dash character in LTREE
interesting, but I like '.' as path separator, it's url-friendly, and easy I used some simple `pathTEXT 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 > > >
Re: [HACKERS] Allowing dash character in LTREE
Ah sorry, first time, I thought it didn't pass It's to support multiple ids (base64 ones are frequent) (or uuid's) in a path. I think it's more practical than an array, for searching and sorting But I understand that LTREE's main purpose is probably more for words 'breadcrumbs' etc.. 2017-05-20 18:31 GMT+02:00 David G. Johnston <david.g.johns...@gmail.com>: > On Sat, May 20, 2017 at 1:27 AM, Cyril Auburtin <cyril.aubur...@gmail.com> > wrote: > >> It could be useful to allow the `-` char in allowed LTREE label >> characters (currently a-zA-Z0-9_ https://www.postgre >> sql.org/docs/9.6/static/ltree.html) >> >> The reason is to allow to use more easily base64 ids, (like >> https://github.com/dylang/shortid, ...), uuid's too in labels >> >> `-` is also not used as a query operator as a plus >> >> >> source: https://doxygen.postgresql.org/ltree_8h.html#a1cb5d5 >> dd0c364d720854e8a250967dd1 >> > > This is the third time you've posted this suggestion. Its been seen by > the people you are sending it to. > > I don't follow how this helps for UUID - they are not usually generated > hierarchically... > > I'll +1 the thought, but I won't be providing a patch. > > David J. > >
[HACKERS] Allowing dash character in LTREE
It could be useful to allow the `-` char in allowed LTREE label characters (currently a-zA-Z0-9_ https://www.postgresql.org/docs/9.6/static/ltree.html) The reason is to allow to use more easily base64 ids, (like https://github.com/dylang/shortid, ...), uuid's too in labels `-` is also not used as a query operator as a plus source: https://doxygen.postgresql.org/ltree_8h.html# a1cb5d5dd0c364d720854e8a250967dd1
[HACKERS] Allowing dash character in LTREE
I propose to allow the `-` char in allowed label characters (currently a-zA-Z0-9_ https://www.postgresql.org/docs/9.6/static/ltree.html) The reason is to allow to use more easily base64 ids, (like https://github.com/dylang/shortid, ...), uuid's too in labels `-` is also not used as a query operator as a plus source: https://doxygen.postgresql.org/ltree_8h.html# a1cb5d5dd0c364d720854e8a250967dd1
[HACKERS] Allowing dash character in LTREE
I propose to allow the `-` char in allowed label characters The reason is to allow to use more easily base64 ids, (like https://github.com/dylang/shortid, ...), uuid's too in labels `-` is also not used as a query operator as a plus source: https://doxygen.postgresql.org/ltree_8h.html#a1cb5d5dd0c364d720854e8a250967dd1