SQL · Array and set-returning functions

array_position()

The one-based position of a value in an array. PostgreSQL.

sqlRunnable example sql course

Syntax

array_position(array, value)

Example

Open in the lab

-- PostgreSQL
-- SELECT array_position(ARRAY['a','b'], 'b');

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.