In SQL, the coalesce or NVL function takes null values and replaces them with a defined value.<\/p>\n
To replicate this in RethinkDB, you can use the ‘branch’ function to test for null and remove it:<\/p>\n
\nr.db('test')\n .table('users')\n .map(\n (doc) => { \n return\n {\n first_name: null\n }\n }\n ).map( \n (doc) => {\n return {\n first_name: \n r.branch(\n doc('first_name').eq(null), \n 'no name', \n doc('first_name') \n )\n }\n }\n )\n<\/pre>\nIf you are stuck instead with undefined values, you can instead merge in values for these columns:<\/p>\n
\nr.db('test').table('users')\n .map(\n (doc) => { return r.expr(\n {\n first_name: '',\n last_name: ''\n }\n ).merge(doc) }\n )\n<\/pre>\n","protected":false},"excerpt":{"rendered":"In SQL, the coalesce or NVL function takes null values and replaces them with a defined value. To replicate this in RethinkDB, you can use the ‘branch’ function to test for null and remove it: r.db(‘test’) .table(‘users’) .map( (doc) => { return { first_name: null } } ).map( (doc) => { return { first_name: r.branch( … <\/p>\n