Re: Order of rows on inserting multiple rows

[Andrey Shcherbakov]

I'm need not only last inserted id, i need to map inserted values to their ids.
For example, i insert values ('dog'), ('cat'), ('cow') i one insert statement. And in my code i want to assign to each value its ID. Like this:
1 -> dog
2 -> cat
3 -> cow

If i insert simple values - that's ok - i can select them back. But i insert JSON documents and it is not good to make SELECT WHERE json IN (...). I even doubt that this will work...

So i'm looking for some elegant solution.