Re: [GENERAL] Appending new data to existing field of Json data type

2014-10-30 Thread VENKTESH GUTTEDAR
Thanks Adrian Klaver, Its really helped me to solve my problem, ya i have example_list = jsonfield.JSONField() in models. Apologies i did not mention that. but anyways thank again. On Thu, Oct 30, 2014 at 8:09 PM, Adrian Klaver wrote: > On 10/29/2014 11:26 PM, VENKTESH GUTTEDAR wrote: > >> @Adri

Re: [GENERAL] Appending new data to existing field of Json data type

2014-10-30 Thread Adrian Klaver
On 10/29/2014 11:26 PM, VENKTESH GUTTEDAR wrote: @Adrian Klaver, Thanks for this idea but still m really confused with how to update the json filed in the DB. is there any way to update the json field in the DB through view.? Realized I should have shown at least one concrete example so, assum

Re: [GENERAL] Appending new data to existing field of Json data type

2014-10-30 Thread Adrian Klaver
On 10/29/2014 11:26 PM, VENKTESH GUTTEDAR wrote: @Adrian Klaver, Thanks for this idea but still m really confused with how to update the json filed in the DB. is there any way to update the json field in the DB through view.? Sure, how you would normally update a value. Assuming id is unique:

Re: [GENERAL] Appending new data to existing field of Json data type

2014-10-29 Thread VENKTESH GUTTEDAR
@Adrian Klaver, Thanks for this idea but still m really confused with how to update the json filed in the DB. is there any way to update the json field in the DB through view.? On Wed, Oct 29, 2014 at 7:37 PM, Adrian Klaver wrote: > On 10/29/2014 01:06 AM, VENKTESH GUTTEDAR wrote: > >> Ya agreed

Re: [GENERAL] Appending new data to existing field of Json data type

2014-10-29 Thread Adrian Klaver
On 10/29/2014 01:06 AM, VENKTESH GUTTEDAR wrote: Ya agreed thats not legal JSON, that was typing mistake sorry for that, let me make you clear what i need exactly, I have table named (exampleTable) with json field as (example_list), and when i say SELECT * FROM exampleTable; id | example_list

Re: [GENERAL] Appending new data to existing field of Json data type

2014-10-29 Thread VENKTESH GUTTEDAR
Ya agreed thats not legal JSON, that was typing mistake sorry for that, let me make you clear what i need exactly, I have table named (exampleTable) with json field as (example_list), and when i say SELECT * FROM exampleTable; id | example_list ---+--

Re: [GENERAL] Appending new data to existing field of Json data type

2014-10-29 Thread Michael Paquier
On Wed, Oct 29, 2014 at 3:42 PM, VENKTESH GUTTEDAR wrote: > As i am new to postgresql, i am learning through experimenting things. > > i have a table with json data type field, so there is some data for > example : > > { [ { a:b, b:c } ] } > > and now if i append data then it s

[GENERAL] Appending new data to existing field of Json data type

2014-10-28 Thread VENKTESH GUTTEDAR
Hello, As i am new to postgresql, i am learning through experimenting things. i have a table with json data type field, so there is some data for example : { [ { a:b, b:c } ] } and now if i append data then it should be like : { [ { a:b, b:c }, { e:f, g:h } ] }