Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Allowing dash character in LTREE - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: [HACKERS] Allowing dash character in LTREE
Date
Msg-id CAKFQuwbetwiRC2bucHw4OD=EmpJvao6NbuZQbX9=UyaEQ_6jfg@mail.gmail.com
Whole thread Raw
In response to [HACKERS] Allowing dash character in LTREE  (Cyril Auburtin <cyril.auburtin@gmail.com>)
Responses Re: [HACKERS] Allowing dash character in LTREE  (Cyril Auburtin <cyril.auburtin@gmail.com>)
List pgsql-hackers
Tree view
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 by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Race conditions with WAL sender PID lookups
Next
From: Magnus Hagander
Date:
Subject: Re: [HACKERS] Making replication commands case-insensitive