ins0mnia -- IRC - 2013.12.11

gistfile1.js

r.db('todomvc').table('posts').map( function(post) {
    return post.merge({
        comments: r.db('todomvc').table('comments').filter( function(comment) {
            comment("pid").eq( post("id") )
        }).coerceTo("ARRAY")
    })
})


// If you have an index on pid for the table comments, you can do
r.db('todomvc').table('posts').map( function(post) {
    return post.merge({
        comments: r.db('todomvc').table('comments').getAll(post("id"), {index: "pid"}).coerceTo("ARRAY")
    })
})