samedi 3 janvier 2015

Nested Postgres Json Query


While using Json type in postgresql


data




{{"name":"Roy","Country":"USA","Hobby":"Swim"},{name:"Roy",Country:"USA","Hobby":"Crcket"},{"name":"Anam","country":"Greece","Hobby":"Polo"}}


how can i get all matching values with data->>name="Roy".


O/P should be : {{"name":"Roy","Country":"USA","Hobby":"Swim"},{name:"Roy",Country:"USA","Hobby":"Crcket"}}


How can i query for such condition ?





Aucun commentaire:

Enregistrer un commentaire