Re: Ltree: set of allowed charcters is limited to [A-Za-z0-9_]. Could the dash "-" be included?

[joernbs <joern.jaenecke@xxxxxxxxx>]

Hello David,

I think this is a misunderstanding.

The seperator in ltree is the dot (.) , of cause I did not asked to change that.

I asked about to expand allowed characters in the ltree-string [A-Za-z0-9_] to [a-zA-Z0-9_/- ] including dash(-), slash(/) and whitespace( ), common charcaters in wording or real path-names to be transformed into and from ltree.


Jörn

Am Sa., 27. Okt. 2018 um 18:14 Uhr schrieb David G. Johnston <david.g.johnston@xxxxxxxxx>:

On Saturday, October 27, 2018, joernbs <joern.jaenecke@xxxxxxxxx> wrote:

Dear friends,

I would like to use ltree for search paths in a warehouse application, something like "Material-Entry-01.Main-Aisle.Shelf-Aisle-R07/R08.R07-12-03"

Unfortunately I can not use common separators like dash (-) or slash(/)

Documentation states only thes characters [A-Za-z0-9_] are allowed.https://www.postgresql.org/docs/10/static/ltree.html

I don’t see how this would be possible to do with the existing type - too much potential breakage of existing data.  Your example itself shows why using dash as a separator is a bad idea.

David J.