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

From Kevin Grittner
Subject Re: JSON Patch for PostgreSQL - BSON Support?
Date
Msg-id 4C696F3702000025000346D1@gw.wicourts.gov
Whole thread Raw
In response to Re: JSON Patch for PostgreSQL - BSON Support?  (Charles Pritchard <chuck@jumis.com>)
Responses Re: JSON Patch for PostgreSQL - BSON Support?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: JSON Patch for PostgreSQL - BSON Support?  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
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).  Or do we invent our own flavors of one or both to cover the
mismatch?
-Kevin


pgsql-hackers by date:

Previous
From: Charles Pritchard
Date:
Subject: Re: JSON Patch for PostgreSQL - BSON Support?
Next
From: Alex Hunsaker
Date:
Subject: Re: Todays git migration results