[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Ltree: set of allowed charcters is limited to [A-Za-z0-9_]. Could the dash "-" be included?
From:       joernbs <joern.jaenecke () gmail ! com>
Date:       2018-10-28 9:31:32
Message-ID: CAHqoMn_BQPX-jZs21W-T1=f1aJKQmios2f61+LdZ0kyRU+W-BA () mail ! gmail ! com
[Download RAW message or body]

Hello David,

I think this is a misunderstanding.
The seperator in ltree is the dot (.) , of cause I did not asked to change
that.
I asked about to expand allowed characters in the ltree-string [A-Za-z0-9_]
to [a-zA-Z0-9_/- ] including dash(-), slash(/) and whitespace( ), common
charcaters in wording or real path-names to be transformed into and from
ltree.

Jörn

Am Sa., 27. Okt. 2018 um 18:14 Uhr schrieb David G. Johnston <
david.g.johnston@gmail.com>:

> 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.  Your example itself shows why
> using dash as a separator is a bad idea.
>
> David J.
>
>

[Attachment #3 (text/html)]

<div dir="ltr"><div dir="ltr"><div><br clear="all"></div><div>Hello \
David,<br></div><div><br></div><div>I think this is a misunderstanding. \
<br></div><div>The seperator in ltree is the dot (.) , of cause I did not asked to \
change that.<br></div><div>I asked about to expand allowed characters in the \
ltree-string  <span class="m_7570488182931878979gmail-im"><code>[A-Za-z0-9_] to \
[a-zA-Z0-9_/- ] including dash(-), slash(/) and whitespace( ), common charcaters in \
wording or real path-names to be transformed into and from ltree. \
<br></code></span></div><br><div>Jörn<br></div></div></div><br><div \
class="gmail_quote"><div dir="ltr">Am Sa., 27. Okt. 2018 um 18:14  Uhr schrieb David \
G. Johnston &lt;<a href="mailto:david.g.johnston@gmail.com" \
target="_blank">david.g.johnston@gmail.com</a>&gt;:<br></div><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">On Saturday, October 27, 2018, joernbs &lt;<a \
href="mailto:joern.jaenecke@gmail.com" \
target="_blank">joern.jaenecke@gmail.com</a>&gt; wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div \
dir="ltr"><div>Dear friends,</div><div><br></div><div>I would like to use ltree for \
search paths in a warehouse application, something like \
&quot;Material-Entry-01.Main-Aisle.Shelf-Aisle-R07/R08.R07-12-03&quot;</div><div>Unfortunately \
I can not use common separators like dash (-) or slash(/) \
<br></div><div><br></div><div>Documentation states only thes characters \
<code>[A-Za-z0-9_]</code> are allowed.<a \
href="https://www.postgresql.org/docs/10/static/ltree.html" \
target="_blank">https://www.postgresql.org/docs/10/static/ltree.html</a></div></div></div></div></div></blockquote><div><br></div><div>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.</div><div><br></div><div>David J.</div><div><br></div> \
</blockquote></div>



[prev in list] [next in list] [prev in thread] [next in thread]