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.
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 |
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 |