David E. Wheeler-3 wrote > I like JSONB because: > > 1. The "B" means "binary" > 2. The "B" means "second" > 3. It's short > 4. See also BYTEA.
"json_strict" : Not sure about the "bytea" reference off-hand... I was pondering "jsons" which meets the short property just fine and the trailing "s" would stand for "strict" which is the user-visible semantic that this type exhibits rather than some less-visible "binary" attribute which most users would not really care about. I dislike the implication of plural-ness that the "s" imparts, though. Implication of "second" doesn't seem that important since both types provide useful semantics. I can imagine where the short aspect will lead people to accidentally type "json" where they mean to use "jsonb" and having a just a single extra character will increase the likelihood they will not notice. Knowing about and having used "json_strict" previously it will be more probable that such users will noticeably feel something is missing if they drop the whole "_strict" suffix. So, I'll toss out "json_strict" for my bikeshed contribution. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/additional-json-functionality-tp5777975p5778770.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers