> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sdf.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Other Expressions

## `add_months`

*Supported Signatures*

```sql theme={null}
function add_months(varchar, bigint) returns timestamp
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_ADD_MONTHS.html)

## `any_value`

*Supported Signatures*

```sql theme={null}
function any_value($1) returns $1
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_ANY_VALUE.html)

## `array`

*Supported Signatures*

```sql theme={null}
function array($1, ...) returns super
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_array.html)

## `array_flatten`

*Supported Signatures*

```sql theme={null}
function array_flatten(super) returns super
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/array_flatten.html)

## `bpcharcmp`

*Supported Signatures*

```sql theme={null}
function bpcharcmp(varchar, varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_BPCHARCMP.html)

## `bttext_pattern_cmp`

*Supported Signatures*

```sql theme={null}
function bttext_pattern_cmp(varchar, varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_BTTEXT_PATTERN_CMP.html)

## `can_json_parse`

*Supported Signatures*

```sql theme={null}
function can_json_parse(varchar) returns boolean
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/CAN_JSON_PARSE.html)

## `cbrt`

*Supported Signatures*

```sql theme={null}
function cbrt(float) returns float
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_CBRT.html)

## `ceiling`

*Supported Signatures*

```sql theme={null}
function ceiling(float) returns float
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/c_SQL_functions.html)

## `charindex`

*Supported Signatures*

```sql theme={null}
function charindex(varchar, varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_CHARINDEX.html)

## `collate`

*Supported Signatures*

```sql theme={null}
function collate(varchar, varchar) returns varchar
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_COLLATE.html)

## `cot`

*Supported Signatures*

```sql theme={null}
function cot(float) returns float
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_COT.html)

## `crc32`

*Supported Signatures*

```sql theme={null}
function crc32(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/crc32-function.html)

## `decimal_precision`

*Supported Signatures*

```sql theme={null}
function decimal_precision(super) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_decimal_precision.html)

## `decimal_scale`

*Supported Signatures*

```sql theme={null}
function decimal_scale(super) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_decimal_scale.html)

## `degrees`

*Supported Signatures*

```sql theme={null}
function degrees(float) returns float
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_DEGREES.html)

## `dexp`

*Supported Signatures*

```sql theme={null}
function dexp(float) returns float
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_DEXP.html)

## `difference`

*Supported Signatures*

```sql theme={null}
function difference(varchar, varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/DIFFERENCE.html)

## `dlog1`

*Supported Signatures*

```sql theme={null}
function dlog1(float) returns float
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_DLOG1.html)

## `dlog10`

*Supported Signatures*

```sql theme={null}
function dlog10(float) returns float
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_DLOG10.html)

## `farmfingerprint64`

*Supported Signatures*

```sql theme={null}
function farmfingerprint64(varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_FARMFINGERPRINT64.html)

## `fnv_hash`

*Supported Signatures*

```sql theme={null}
function fnv_hash(varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_FNV_HASH.html)

## `from_hex`

*Supported Signatures*

```sql theme={null}
function from_hex(varchar) returns varbyte
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_FROM_HEX.html)

## `from_varbyte`

*Supported Signatures*

```sql theme={null}
function from_varbyte(varbyte, varchar) returns varbyte
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_FROM_VARBYTE.html)

## `func_sha1`

*Supported Signatures*

```sql theme={null}
function func_sha1(varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/FUNC_SHA1.html)

## `getbit`

*Supported Signatures*

```sql theme={null}
function getbit(varbyte, bigint) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_GETBIT.html)

## `greatest`

*Supported Signatures*

```sql theme={null}
function greatest($1, ...) returns $1
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/c_SQL_functions.html)

## `interval_cmp`

*Supported Signatures*

```sql theme={null}
function interval_cmp(varchar, varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_INTERVAL_CMP.html)

## `is_array`

*Supported Signatures*

```sql theme={null}
function is_array(super) returns boolean
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_is_array.html)

## `is_bigint`

*Supported Signatures*

```sql theme={null}
function is_bigint(super) returns boolean
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_is_bigint.html)

## `is_boolean`

*Supported Signatures*

```sql theme={null}
function is_boolean(super) returns boolean
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_is_boolean.html)

## `is_char`

*Supported Signatures*

```sql theme={null}
function is_char(super) returns boolean
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_is_char.html)

## `is_decimal`

*Supported Signatures*

```sql theme={null}
function is_decimal(super) returns boolean
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_is_decimal.html)

## `is_float`

*Supported Signatures*

```sql theme={null}
function is_float(super) returns boolean
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_is_float.html)

## `is_object`

*Supported Signatures*

```sql theme={null}
function is_object(super) returns boolean
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_is_object.html)

## `is_scalar`

*Supported Signatures*

```sql theme={null}
function is_scalar(super) returns boolean
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_is_scalar.html)

## `is_smallint`

*Supported Signatures*

```sql theme={null}
function is_smallint(super) returns boolean
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_is_smallint.html)

## `is_valid_json`

*Supported Signatures*

```sql theme={null}
function is_valid_json(varchar) returns boolean
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/IS_VALID_JSON.html)

## `is_valid_json_array`

*Supported Signatures*

```sql theme={null}
function is_valid_json_array(varchar) returns boolean
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/IS_VALID_JSON_ARRAY.html)

## `is_varchar`

*Supported Signatures*

```sql theme={null}
function is_varchar(super) returns boolean
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_is_varchar.html)

## `json_extract_array_element_text`

*Supported Signatures*

```sql theme={null}
function json_extract_array_element_text(varchar, bigint) returns varchar
function json_extract_array_element_text(varchar, bigint, boolean) returns varchar
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/JSON_EXTRACT_ARRAY_ELEMENT_TEXT.html)

## `json_extract_path_text`

*Supported Signatures*

```sql theme={null}
function json_extract_path_text(varchar, varchar) returns varchar
function json_extract_path_text(varchar, varchar, varchar) returns varchar
function json_extract_path_text(varchar, varchar, varchar, varchar) returns varchar
function json_extract_path_text(varchar, varchar, varchar, varchar, varchar) returns varchar
function json_extract_path_text(varchar, varchar, varchar, varchar, varchar, varchar) returns varchar
function json_extract_path_text(varchar, varchar, boolean) returns varchar
function json_extract_path_text(varchar, varchar, varchar, boolean) returns varchar
function json_extract_path_text(varchar, varchar, varchar, varchar, boolean) returns varchar
function json_extract_path_text(varchar, varchar, varchar, varchar, varchar, boolean) returns varchar
function json_extract_path_text(varchar, varchar, varchar, varchar, varchar, varchar, boolean) returns varchar
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/JSON_EXTRACT_PATH_TEXT.html)

## `json_parse`

*Supported Signatures*

```sql theme={null}
function json_parse(varchar) returns super
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/JSON_PARSE.html)

## `json_serialize`

*Supported Signatures*

```sql theme={null}
function json_serialize($1) returns varchar
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/JSON_SERIALIZE.html)

## `json_serialize_to_varbyte`

*Supported Signatures*

```sql theme={null}
function json_serialize_to_varbyte($1) returns varbyte
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/JSON_SERIALIZE_TO_VARBYTE.html)

## `json_size`

*Supported Signatures*

```sql theme={null}
function json_size(super) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_json_size.html)

## `json_typeof`

*Supported Signatures*

```sql theme={null}
function json_typeof(super) returns varchar
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_json_typeof.html)

## `last_day`

*Supported Signatures*

```sql theme={null}
function last_day(varchar) returns date
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_LAST_DAY.html)

## `least`

*Supported Signatures*

```sql theme={null}
function least($1, ...) returns $1
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/c_SQL_functions.html)

## `len`

*Supported Signatures*

```sql theme={null}
function len(varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_LEN.html)

## `md5`

*Supported Signatures*

```sql theme={null}
function md5(varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_MD5.html)

## `mod`

*Supported Signatures*

```sql theme={null}
function mod(bigint, bigint) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_MOD.html)

## `months_between`

*Supported Signatures*

```sql theme={null}
function months_between(varchar, varchar) returns float
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_MONTHS_BETWEEN_function.html)

## `murmur3_32_hash`

*Supported Signatures*

```sql theme={null}
function murmur3_32_hash(varchar) returns bigint
function murmur3_32_hash(varchar, bigint) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/MURMUR3_32_HASH.html)

## `next_day`

*Supported Signatures*

```sql theme={null}
function next_day(varchar, varchar) returns date
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_NEXT_DAY.html)

## `nvl`

*Supported Signatures*

```sql theme={null}
function nvl($1, ...) returns $1
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_NVL_function.html)

## `nvl2`

*Supported Signatures*

```sql theme={null}
function nvl2($1, $2, $2) returns $2
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_NVL2.html)

## `octetindex`

*Supported Signatures*

```sql theme={null}
function octetindex(varchar, varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/OCTETINDEX.html)

## `pi`

*Supported Signatures*

```sql theme={null}
function pi() returns float
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_PI.html)

## `quote_ident`

*Supported Signatures*

```sql theme={null}
function quote_ident(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_QUOTE_IDENT.html)

## `quote_literal`

*Supported Signatures*

```sql theme={null}
function quote_literal(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_QUOTE_LITERAL.html)

## `radians`

*Supported Signatures*

```sql theme={null}
function radians(float) returns float
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_RADIANS.html)

## `reclassify`

Changes the classification label of the first argument from the expected classifier specified by the second argument to the desired classifier specified by the third. The expected and desired classifiers must belong to the same classifier group. No other classifiers attached to the first argument are impacted. The function will emit a warning if the the first argument does not have the expected classifier

*Examples:*

```sql examples.sql theme={null}
select reclassify(12345, 'pii.clear_text', 'pii.masked') as value; -- value '12345'
```

*Supported Signatures*

```sql theme={null}
function reclassify($1, varchar, varchar) returns $1
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/c_SQL_functions.html)

## `regexp_instr`

*Supported Signatures*

```sql theme={null}
function regexp_instr(varchar, varchar) returns bigint
function regexp_instr(varchar, varchar, bigint) returns bigint
function regexp_instr(varchar, varchar, bigint, bigint) returns bigint
function regexp_instr(varchar, varchar, bigint, bigint, bigint) returns bigint
function regexp_instr(varchar, varchar, bigint, bigint, bigint, varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/REGEXP_INSTR.html)

## `regexp_substr`

*Supported Signatures*

```sql theme={null}
function regexp_substr(varchar, varchar) returns varchar
function regexp_substr(varchar, varchar, varchar) returns varchar
function regexp_substr(varchar, varchar, varchar, bigint) returns varchar
function regexp_substr(varchar, varchar, varchar, bigint, varchar) returns varchar
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/REGEXP_SUBSTR.html)

## `replicate`

*Supported Signatures*

```sql theme={null}
function replicate(varchar, bigint) returns varchar
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_REPLICATE.html)

## `sha`

*Supported Signatures*

```sql theme={null}
function sha(varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/SHA.html)

## `sha1`

*Supported Signatures*

```sql theme={null}
function sha1(varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/SHA1.html)

## `sha2`

*Supported Signatures*

```sql theme={null}
function sha2(varchar, bigint) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/SHA2.html)

## `sign`

*Supported Signatures*

```sql theme={null}
function sign(float) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_SIGN.html)

## `size`

*Supported Signatures*

```sql theme={null}
function size($1) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_SIZE.html)

## `soundex`

*Supported Signatures*

```sql theme={null}
function soundex(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/SOUNDEX.html)

## `split_to_array`

*Supported Signatures*

```sql theme={null}
function split_to_array(varchar, varchar) returns super
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/split_to_array.html)

## `strtol`

*Supported Signatures*

```sql theme={null}
function strtol(varchar, bigint) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_STRTOL.html)

## `subarray`

*Supported Signatures*

```sql theme={null}
function subarray(super, bigint, bigint) returns super
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_subarray.html)

## `text_to_int_alt`

*Supported Signatures*

```sql theme={null}
function text_to_int_alt(varchar) returns bigint
function text_to_int_alt(varchar, varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_TEXT_TO_INT_ALT.html)

## `text_to_numeric_alt`

*Supported Signatures*

```sql theme={null}
function text_to_numeric_alt(varchar) returns float
function text_to_numeric_alt(varchar, varchar) returns float
function text_to_numeric_alt(varchar, bigint, bigint) returns float
function text_to_numeric_alt(varchar, varchar, bigint, bigint) returns float
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_TEXT_TO_NUMERIC_ALT.html)

## `textlen`

*Supported Signatures*

```sql theme={null}
function textlen(varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_TEXTLEN.html)

## `to_char`

*Supported Signatures*

```sql theme={null}
function to_char($1, varchar) returns varchar
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_TO_CHAR.html)

## `to_hex`

*Supported Signatures*

```sql theme={null}
function to_hex(varbyte) returns varchar
function to_hex(bigint) returns varchar
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_TO_HEX.html)

## `to_number`

*Supported Signatures*

```sql theme={null}
function to_number(varchar, varchar) returns float
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_TO_NUMBER.html)

## `to_varbyte`

*Supported Signatures*

```sql theme={null}
function to_varbyte(varchar, varchar) returns varbyte
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_TO_VARBYTE.html)

## `trunc`

*Supported Signatures*

```sql theme={null}
function trunc(varchar) returns date
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_TRUNC.html)