Re: [HACKERS] Allowing dash character in LTREE

Поиск
Список
Период
Сортировка
От Cyril Auburtin
Тема Re: [HACKERS] Allowing dash character in LTREE
Дата
Msg-id CAKteAhHJavQn7pQuWE-_0bOy7bkjbO3V093NfR2gpDNtkz8CCA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Allowing dash character in LTREE  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: [HACKERS] Allowing dash character in LTREE
Список pgsql-hackers
Дерево обсуждения
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>:
On Sat, May 20, 2017 at 1:27 AM, Cyril Auburtin <cyril.auburtin@gmail.com> 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.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.


В списке pgsql-hackers по дате отправления: