octet_length()

Returns the number of bytes in the bitstring.

Arguments & returns

2 overloads

Scalar

Overload link	`bitstring`	Returns
#01	`BIT`	`BIGINT`

Scalar

Number of bytes in blob.

Overload link	`blob`	Returns
#02	`BLOB`	`BIGINT`

SELECT octet_length('1101011'::BITSTRING);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT octet_length('\xAA\xBB'::BLOB);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Used in larger rewrites 1

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

SELECT LENGTH(foo)

In Haybarn

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