sqrt

Description

Returns the square root for a given input and null if input is negative.

Return type

numeric

Domain

This is a scalar function (calculates a single output value for a single input row.)

Categories

Usage

sqrt( arg )

Argument

Type

Required

Multiple

arg

numeric

Required

Only one

Examples

make_col squareroot:sqrt(@.x)

Create a column ‘squareroot’ with the result of the square root of column ‘x’