Re: jsonb array-style subscripting - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: jsonb array-style subscripting
Date
Msg-id 55D2321F.6040605@BlueTreble.com
Whole thread Raw
In response to jsonb array-style subscripting  (Dmitry Dolgov <9erthalion6@gmail.com>)
Responses Re: jsonb array-style subscripting  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
On 8/17/15 12:57 PM, Dmitry Dolgov wrote:
> * is it interesting for the community?

We definitely need better ways to manipulate JSON.

> * is that a good idea to extend the `ArrayRef` for jsonb? If it's
> appropriate, probably we can rename it to `ArrayJsonbRef` of something.
> * what can be improved in the code at the top level (function placement,
> probably, functionality duplication, etc.)?
> * are there any special cases, that I should take care of in this
> implementation?

How would this work when you have a JSON array? Postgres array syntax 
suddenly becoming key/value syntax for JSON seems like a pretty bad idea 
to me. Could a different syntax (maybe {}) be used instead?

I'm not sure having the UPDATE you show cause objects to spring to life 
is so great either.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Test code is worth the space
Next
From: Peter Eisentraut
Date:
Subject: Re: replication slot restart_lsn initialization