Re: WIP Patch: Add a function that returns binary JSONB as a bytea - Mailing list pgsql-hackers

From Andres Freund
Subject Re: WIP Patch: Add a function that returns binary JSONB as a bytea
Date
Msg-id 20181031152249.q2nk6r3f6bxcvph7@alap3.anarazel.de
Whole thread Raw
In response to Re: WIP Patch: Add a function that returns binary JSONB as a bytea  (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>)
Responses Re: WIP Patch: Add a function that returns binary JSONB as a bytea  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
Hi,

On 2018-10-31 11:13:13 -0400, Andrew Dunstan wrote:
> I agree that just sending a blob of the internal format isn't a great idea.

It's entirely unacceptable afaict. Besides the whole "exposing
internals" issue, it's also at least not endianess safe, depends on the
local alignment requirements (which differ both between platforms and
32/64 bit), numeric's internal encoding and probably more.

Greetings,

Andres Freund


pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: WIP Patch: Add a function that returns binary JSONB as a bytea
Next
From: John Naylor
Date:
Subject: Re: PostgreSQL Limits and lack of documentation about them.