Postgres Pro
Downloads
Home   >   mailing lists

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

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

Previous
From: Pavel Stehule
Date:
Subject: Re: [HACKERS] proposal psql \gdesc
Next
From: "David G. Johnston"
Date:
Subject: Re: [HACKERS] Allowing dash character in LTREE