> On 27 Oct 2018, at 18:14, David G. Johnston <david.g.johnston@gmail.com> wrote:
>
>> On Saturday, October 27, 2018, joernbs <joern.jaenecke@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.
Yourexample 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.