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.johns...@gmail.com>: > On Saturday, October 27, 2018, joernbs <joern.jaene...@gmail.com> 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. > >
