> On 27 Oct 2018, at 18:14, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote: > >> 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, I don't think he's talking about separators ;) Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll find there is no forest.
