How to add value in tarantool sql map #9025
Unanswered
DinahoDSGN
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hi.
I came across a problem with adding an element to map like this:
{
"111000" : [
{
"c" : 12412521,
"d" : 1251
},
{
"c" : 1512
"d" : 1251252
}
],
"22200" : [
{
"c" : 1251251512,
"d" : 252
}
]
}
It is necessary to add one more object by type to the array inside 22200
{
"c" : 123
"d" : 42
}
I need to do this as part of the request, please help..
--
CREATE TABLE t
(
a INTEGER PRIMARY KEY UNIQUE,
b MAP
) WITH ENGINE = 'memtx';
insert into t values(123, {'111000':[{'c':12412521,'d':1251},{'c':1512,'d':1251252}],'22200':[{'c':1251251512,'d':252}]})
select b['111000'] from t
Beta Was this translation helpful? Give feedback.
All reactions