Numbers & math Scalar

bit_position()

Returns first starting index of the specified substring within bits, or zero if it is not present. The first (leftmost) bit is indexed 1

Arguments & returns

Scalar

Overload link	`substring`	`bitstring`	Returns
#01	`BIT`	`BIT`	`INTEGER`

SELECT bit_position('010'::BIT, '1110101'::BIT);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.