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. > >
