length()

Number of characters in string.

Arguments & returns

3 overloads

Scalar

SELECT length(42::TINYINT::BIT);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT length([1,2,3]);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT length('Hello🦆');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Used in larger rewrites 3

These examples use length as one part of a larger SQL translation.

ARRAY_INSERT(ARRAY(1, 2, 3), -2, 99)

In DuckDB

CASE WHEN [1, 2, 3] IS NULL THEN NULL ELSE LIST_CONCAT([1, 2, 3][1:LENGTH([1, 2, 3]) + -1], [99], [1, 2, 3][LENGTH([1, 2, 3]) + -1 + 1:]) END

SELECT LENGTH(foo)

In DuckDB

SELECT CASE TYPEOF(foo) WHEN 'BLOB' THEN OCTET_LENGTH(CAST(foo AS BLOB)) ELSE LENGTH(CAST(foo AS TEXT)) END

ARRAY_REMOVE_AT([1, 2, 3], -1)

In DuckDB

CASE WHEN [1, 2, 3] IS NULL THEN NULL ELSE [1, 2, 3][1:LENGTH([1, 2, 3]) + -1] END