Comparison Functions

`greatest`

Returns the largest of the provided values. Examples:

examples.sql

SELECT greatest(1, 2, 3) AS value; -- value '3'

Supported Signatures

function greatest($3, ...) returns $3

Returns the smallest of the provided values. Examples:

examples.sql

SELECT LEAST(5,6,7,1,2,3,4) -- list of columns or values -- value '1'

Supported Signatures

function least($3, ...) returns $3