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 :
>
>
>
>
> Manuel Kniep
> Danziger Str
Manuel Kniep
Danziger Str. 116
10405 Berlin
> Am 20.05.2017 um 10:27 schrieb Cyril Auburtin :
>
> 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
On Sat, May 20, 2017 at 11:26 AM, Cyril Auburtin
wrote:
> Ah sorry, first time, I thought it didn't pass
>
You should check our excellent online mailing list archives before
re-sending.
https://www.postgresql.org/list/
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
On Sat, May 20, 2017 at 1:27 AM, Cyril Auburtin
wrote:
> 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.c
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 a
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 operat
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#a1cb5d5d
