Re: proposal: unescape_text function

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: proposal: unescape_text function
Дата
Msg-id CAFj8pRB5ZeKfiV6Ur8k+-2-7wfqhb5yuD8pKXu=oP6n+Co_f0Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: proposal: unescape_text function  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Ответы Re: proposal: unescape_text function  (Chapman Flack <chap@anastigmatix.net>)
Re: proposal: unescape_text function  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers


st 2. 12. 2020 v 9:23 odesílatel Peter Eisentraut <peter.eisentraut@enterprisedb.com> napsal:
On 2020-11-30 22:15, Pavel Stehule wrote:
>     I would like some supporting documentation on this.  So far we only
>     have
>     one stackoverflow question, and then this implementation, and they are
>     not even the same format.  My worry is that if there is not precise
>     specification, then people are going to want to add things in the
>     future, and there will be no way to analyze such requests in a
>     principled way.
>
>
> I checked this and it is "prefix backslash-u hex" used by Java,
> JavaScript  or RTF -
> https://billposer.org/Software/ListOfRepresentations.html

Heh.  The fact that there is a table of two dozen possible
representations kind of proves my point that we should be deliberate in
picking one.

I do see Oracle unistr() on that list, which appears to be very similar
to what you are trying to do here.  Maybe look into aligning with that.

unistr is a primitive form of proposed function.  But it can be used as a base. The format is compatible with our  "4.1.2.3. String Constants with Unicode Escapes".

What do you think about the following proposal?

1. unistr(text) .. compatible with Postgres unicode escapes - it is enhanced against Oracle, because Oracle's unistr doesn't support 6 digits unicodes.

2. there can be optional parameter "prefix" with default "\". But with "\u" it can be compatible with Java or Python.

What do you think about it?

Pavel

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bharath Rupireddy
Дата:
Сообщение: Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently
Следующее
От: "Drouvot, Bertrand"
Дата:
Сообщение: Re: [UNVERIFIED SENDER] Re: [BUG] orphaned function