JSON parsing

  
postgresql_version

1
PostgreSQL 9.6.2, compiled by Visual C++ build 1800, 64-bit


  
id
json
value

1
1
{"ItemId":"123","IDs":[{"ID":"abc","CodingSystem":"cs1"}],"Name":"test itemgh"}
{"ID":"abc","CodingSystem":"cs1"}

2
1
{"ItemId":"123","IDs":[{"ID":"ghj","CodingSystem":"cs1"}],"Name":"test abc"}
{"ID":"ghj","CodingSystem":"cs1"}