Re: [HACKERS] Allowing dash character in LTREE

Поиск
Список
Период
Сортировка
От Cyril Auburtin
Тема Re: [HACKERS] Allowing dash character in LTREE
Дата
Msg-id CAKteAhEfX=D0AET+wjPh7CfGCEqnV6HumYfgdn2=g4bDdiSMwg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Allowing dash character in LTREE  (Manuel Kniep <rapimo@adeven.com>)
Список pgsql-hackers
Дерево обсуждения
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>:




Manuel Kniep
Danziger Str. 116
10405 Berlin
Am 20.05.2017 um 10:27 schrieb Cyril Auburtin <cyril.auburtin@gmail.com>:

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 



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: [HACKERS] Transactional sequence stuff breaks pg_upgrade
Следующее
От: Ashutosh Sharma
Дата:
Сообщение: Re: [HACKERS] ICU support on Windows