Re: [HACKERS] Context lenses to set/get values in json values.

2014-11-25 Thread Thom Brown
On 8 October 2014 at 20:39, Andrew Dunstan wrote: > > On 10/08/2014 02:04 PM, Thom Brown wrote: > > There is work already being done on providing update operations. >>> >> I've been looking out for that. Has there been a discussion on how >> that would look yet that you could point me to? >> >>

Re: [HACKERS] Context lenses to set/get values in json values.

2014-10-08 Thread Andrew Dunstan
On 10/08/2014 02:04 PM, Thom Brown wrote: There is work already being done on providing update operations. I've been looking out for that. Has there been a discussion on how that would look yet that you could point me to? https://github.com/erthalion/jsonbx Note that a) it's an extension

Re: [HACKERS] Context lenses to set/get values in json values.

2014-10-08 Thread Thom Brown
On 8 October 2014 18:39, Andrew Dunstan wrote: > > On 10/08/2014 12:13 PM, Paweł Cesar Sanjuan Szklarz wrote: >> >> >> >> >> I don't think we need to import Mongo type notation here. But >> there is probably a good case for some functions like: >> >>json_table_agg(anyrecord) -> jso

Re: [HACKERS] Context lenses to set/get values in json values.

2014-10-08 Thread Andrew Dunstan
On 10/08/2014 12:13 PM, Paweł Cesar Sanjuan Szklarz wrote: I don't think we need to import Mongo type notation here. But there is probably a good case for some functions like: json_table_agg(anyrecord) -> json which would work like json_agg() but would return an array of

Re: [HACKERS] Context lenses to set/get values in json values.

2014-10-08 Thread Paweł Cesar Sanjuan Szklarz
On Wed, Oct 8, 2014 at 4:25 PM, Andrew Dunstan wrote: > > On 10/08/2014 04:38 AM, Paweł Cesar Sanjuan Szklarz wrote: > >> Hello. >> >> I am interested in the json type on postgresql. I would like to implement >> additional operations on the json structure that may extract/insert table >> like inf

Re: [HACKERS] Context lenses to set/get values in json values.

2014-10-08 Thread Andrew Dunstan
On 10/08/2014 04:38 AM, Paweł Cesar Sanjuan Szklarz wrote: Hello. I am interested in the json type on postgresql. I would like to implement additional operations on the json structure that may extract/insert table like information from the json tree structure. I have a implementation on javas

[HACKERS] Context lenses to set/get values in json values.

2014-10-08 Thread Paweł Cesar Sanjuan Szklarz
Hello. I am interested in the json type on postgresql. I would like to implement additional operations on the json structure that may extract/insert table like information from the json tree structure. I have a implementation on javascript that shows this type of operations. You can see examples i