ReQL command: +

Command syntax

value + value → value
time + number → time
value.add(value[, value, ...]) → value
time.add(number[, number, ...]) → time

Description

Sum two or more numbers, or concatenate two or more strings or arrays.

The add command can be called in either prefix or infix form; both forms are equivalent. Note that ReQL will not perform type coercion. You cannot, for example, add a string and a number together.

Example: It’s as easy as 2 + 2 = 4.

> (r.expr(2) + 2).run(conn)

4

Example: Concatenate strings.

> (r.expr("foo") + "bar" + "baz").run(conn)

"foobarbaz"

Example: Concatenate arrays.

> (r.expr(["foo", "bar"]) + ["buzz"]).run(conn)

["foo", "bar", "buzz"]

Example: Create a date one year from now.

(r.now() + 365*24*60*60).run(conn)

Example: Use args with add to sum multiple values.

> vals = [10, 20, 30]
> r.add(r.args(vals)).run(conn)

60

Example: Concatenate an array of strings with args.

> vals = ['foo', 'bar', 'buzz']
> r.add(r.args(vals)).run(conn)

"foobarbuzz"

Related commands

• -
• *
• /
• %

Get more help

Couldn't find what you were looking for?

• Ask a question on Stack Overflow
• Chat with us and our community on Slack
• Talk to the team on IRC on #[email protected] — via Webchat
• Ping @rethinkdb on Twitter
• Post an issue on the documentation issue tracker on GitHub