Skip to main content

Column.+

+other

Group: Operators
Aliases: add, concatenate, plus

Documentation​

Element-wise addition. Works on numeric types or text.

Returns a column with results of adding other from each element of self.

Arguments​

  • other: The value to add to self. If other is a column, the addition is performed pairwise between corresponding elements of self and other.

Examples​

Add two columns to each other.​

      import Standard.Examples

      example_plus = Examples.decimal_column + Examples.integer_column

Add a single value to each item in a column.​

      import Standard.Examples

      example_plus = Examples.integer_column + 10

Remarks​

Arithmetic Overflow​

For integer columns, the operation may yield results that will not fit into the range supported by the column. In such case, the in-memory backend will replace such results with Nothing and report a Arithmetic_Overflow warning. The behaviour in Database backends is not specified and will depend on the particular database - it may cause a hard error, the value may be truncated or wrap-around etc.