Thread: [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
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
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.
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.johnston@gmail.com>:
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 plusThis 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.
Ah sorry, first time, I thought it didn't pass
You should check our excellent online mailing list archives before re-sending.
David J.
Manuel Kniep
Danziger Str. 116
10405 Berlin
It could be useful to allow the `-` char in allowed LTREE label characters (currently a-zA-Z0-9_ https://https://github.com/adjust/ltreewww.postgresql.org/docs/9.6/ static/ltree.html)
There is a patched version here
Which allows almost any char but uses '::' as label separator my it's an inspiration to do your own patch.
Manuel
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@adeven.com>:
Am 20.05.2017 um 10:27 schrieb Cyril Auburtin <cyril.auburtin@gmail.com>:
Manuel KniepDanziger Str. 11610405 BerlinIt could be useful to allow the `-` char in allowed LTREE label characters (currently a-zA-Z0-9_ https://https://github.com/adjust/ltreewww.pos tgresql.org/docs/9.6/static/ ltree.html) There is a patched version hereWhich allows almost any char but uses '::' as label separator my it's an inspiration to do your own patch.Manuel