Array

SAFE_ORDINAL

BigQuery

Mengakses elemen array dengan one-based index, mengembalikan NULL jika out of bounds.

Tipe hasil: Element type or NULLDiperbarui: 7 Jan 2026

Syntax

SQL

array[SAFE_ORDINAL(one_based_index)]

one_based_indexINT64wajib

Index dimulai dari 1

SQL

1 SELECT
2   arr[SAFE_ORDINAL(1)] as first,
3   arr[SAFE_ORDINAL(10)] as out_of_bounds
4 FROM (SELECT ['a', 'b', 'c'] as arr);

Akses aman dengan one-based index.

Hasil

first	out_of_bounds
a	NULL

1	SELECT
2	arr[SAFE_ORDINAL(1)] as first,
3	arr[SAFE_ORDINAL(10)] as out_of_bounds
4	FROM (SELECT ['a', 'b', 'c'] as arr);