Re: JSON Patch for PostgreSQL - BSON Support?

Joseph Adams <joeyadams3.14159@gmail.com> writes:
> Others already mentioned that you can't convert 2 billion byte long
> JSON strings to BSON.  Another issue is that BSON cannot encode all
> JSON numbers without precision loss.

As somebody already mentioned, the former isn't likely to be an issue
for us anytime in the foreseeable future, because we can't push around
datum values more than 1GB large anyhow.  The latter seems like a pretty
nasty problem though.

I'm good with just dropping this idea for the moment.  The Google hit
statistics that were cited earlier show that there's not enough interest
in BSON to justify a separate datatype, which is what it would
apparently need to be.
        regards, tom lane