Hi
24.10.2018, 17:40, "David G. Johnston" <david.g.johnston@gmail.com>:
> On Wed, Oct 24, 2018 at 7:25 AM Sergei Kornilov <sk@zsrv.org> wrote:
>
>> DETAIL: \u0000 cannot be converted to text.
>>
>> Well, requested text type can not have \u0000 byte. But seems strange: we test json type with this value but raise
sameerror for -> operator:
>>
>> We allow write such json to table, we allow read whole json, but we can not use native operators. Is this behavior
expected?
>
> It isn't that different than saying:
>
> '123bcd'::integer -- error, invalid input for type integer
>
> While text can hold just about everything it cannot contain an actual ASCII NUL character and so a JSON value with a
unicoderepresented NUL cannot be converted to text. Text doesn't have a stored concept of escaped values, using escape
isonly valid during entry.
Yes, it is reasonable for operators which returns text, such as ->> (and i do not have question on this)
I was surprised by operators with json type result
regards, Sergei