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.
