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

From: Alban Hertroys <haramrae(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: joernbs <joern(dot)jaenecke(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Ltree: set of allowed charcters is limited to [A-Za-z0-9_]. Could the dash "-" be included?
Date: 2018-10-27 19:02:12
Message-ID: D42E357D-14AD-4829-A636-F6C78A8A27B4@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


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

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Moench-Tegeder 2018-10-27 22:05:50 Re: rw_redis_fdw: SQL Errors when statement is within a function
Previous Message Adrian Klaver 2018-10-27 19:00:53 Re: rw_redis_fdw: SQL Errors when statement is within a function

Browse pgsql-hackers by date

  From Date Subject
Next Message Narayanan V 2018-10-27 19:30:57 Re: Postgres restore issue
Previous Message Andres Freund 2018-10-27 18:56:56 Re: [RFC] Removing "magic" oids