can you please help me getting query for the following , i couldn't figure
out this
select all from orders table where details->quantity is greater than 2?
select * from orders Where document->'orderid'='3' -- this works , I get
results back
select * from orders Where document->'key'<'90' -- -- this works , I get
results back
Hers's the schema
create table orders (document jsonb)
insert into orders values
('{"orderid":3,"key":100,"total":3510.20,"ref_id":"AFV",
"details":
[
{"product":3,"quantity":20,"price":2.1,"c":"something"},
{"product":13,"quantity":2,"price":1.1},
{"product":18,"quantity":4,"price":0.3}
]
}')
Insert Into orders values ('{"orderid":2, "key":20, "total":510.20,
"ref_id":"zzz"}')
insert into orders values ('{"orderid":5, "key":100, "total":3510.20,
"ref_id":"AFV",
"details":
[
{"product":3,"quantity":20,"price":2.1},
{"product":13,"quantity":2,"price":1.1},
{"product":18,"quantity":4,"price":0.3}
]
}')
insert into orders values ('{"ref_id": "AFV", "total": 3510.20,
"details":
[
{"c": "something", "price": 2.1, "product": 3, "quantity": 20},
{"price": 1.1, "product": 13, "quantity": 2},
{"price": 0.3, "product": 18, "quantity": 4}
], "orderid": 3, "key": 100}')
--
View this message in context: http://postgresql.nabble.com/query-nested-levels-in-jsonb-tp5852918.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
