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