Re: JSON Patch for PostgreSQL - BSON Support? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: JSON Patch for PostgreSQL - BSON Support?
Date
Msg-id 25452.1282001077@sss.pgh.pa.us
Whole thread Raw
In response to Re: JSON Patch for PostgreSQL - BSON Support?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: JSON Patch for PostgreSQL - BSON Support?
List pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> Charles Pritchard <chuck@jumis.com> wrote:
>> Storing internally as BSON (if it holds up to its premise) would
>> mean more efficient traversal of internal objects in the future,
>> if we were to have JSON-related functions/selectors.
> How about the fact that not all JSON objects can be represented in
> BSON (if the JSON object has a very long string), and not all BSON
> objects can be represented in JSON (if the BSON object has an
> array).

Well, if it's not just a binary encoding of JSON, I think we can forget
about it ... certainly it won't work in the form I was visualizing.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Todays git migration results
Next
From: Andres Freund
Date:
Subject: Re: JSON Patch for PostgreSQL - BSON Support?