Postgres Pro
Downloads
Home   >   mailing lists

[HACKERS] Allowing dash character in LTREE - Mailing list pgsql-hackers

From Cyril Auburtin
Subject [HACKERS] Allowing dash character in LTREE
Date
Msg-id CAKteAhH2FDH8TpK5nc4AVCvzvGx4qP+bi8Vk9BqjPaOYupYi1Q@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] Allowing dash character in LTREE  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: [HACKERS] Allowing dash character in LTREE  (Manuel Kniep <rapimo@adeven.com>)
List pgsql-hackers
Tree view
It could be useful to allow the `-` char in allowed LTREE label characters  (currently a-zA-Z0-9_ https://www.postgresql.org/docs/9.6/static/ltree.html)

The reason is to allow to use more easily base64 ids, (like https://github.com/dylang/shortid, ...), uuid's too in labels

`-` is also not used as a query operator as a plus


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: [HACKERS] type cache for concat functions
Next
From: Amit Kapila
Date:
Subject: Re: [HACKERS] statement_timeout is not working as expected with postgres_fdw