From the following JSON, how do I remove the dog with the least height

{
   _id:0
   "name":"Andy",
   "pets":[
      {
         "type":"dog","name":"max","height":120
      },
      {
         "type":"dog","name":"rover","height":44
      },
      {
         "type":"dog","name":"katie","height":100
      },
      {
         "type":"cat","name":"minni"
      }
   ]

--SD

I can think of two possibillities:

(a) find all the documents with dogs, for each document found loop the pets
to find the lowest dog, then remove it:

(b) use aggregate or mapReduce to find the lowest dogs per _id and remove it

You can find an analog expample (for node.js) on
https://gist.github.com/4080463 (the mapReduce (2nd file) actually doesnt
remove the lowest score but you can add this to the finalize function

cheers

SORRY,

add remove to the finalize function does not work, that was stupid of me.
You'll have to loop the resulting collection of the mapReduce

That helps, thanks for the example.