Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.snowflake.com/en/sql-reference/functions/array_position below:

Website Navigation

• Reference
• Function and stored procedure reference
• Semi-structured and structured data

ARRAY_POSITION | Snowflake Documentation

Categories:

Semi-structured and structured data functions (Array/Object)

Returns the index of the first occurrence of an element in an array.

ARRAY_POSITION( <variant_expr> , <array> )

Copy

value_expr

Value to find in array.

• If array is a semi-structured ARRAY, value_expr must evaluate to a VARIANT.

• If array is a structured ARRAY, value_expr must evaluate to a type that is comparable to the type of the ARRAY.

array

The ARRAY to search.

The function returns an INTEGER specifying the position of value_expr in array.

• The return value is 0-based, not 1-based. In other words, if the value_expr matches the first element in the array, this function returns 0, not 1.

• If the value is not contained in the ARRAY, the function returns NULL.

• If you specify NULL for value_expr, the function returns the position of the first NULL in the array.

The examples below show how to use this function:

SELECT ARRAY_POSITION('hello'::variant, array_construct('hello', 'hi'));
+------------------------------------------------------------------+
| ARRAY_POSITION('HELLO'::VARIANT, ARRAY_CONSTRUCT('HELLO', 'HI')) |
|------------------------------------------------------------------|
|                                                                0 |
+------------------------------------------------------------------+

Copy

SELECT ARRAY_POSITION('hi'::variant, array_construct('hello', 'hi'));
+---------------------------------------------------------------+
| ARRAY_POSITION('HI'::VARIANT, ARRAY_CONSTRUCT('HELLO', 'HI')) |
|---------------------------------------------------------------|
|                                                             1 |
+---------------------------------------------------------------+

Copy

SELECT ARRAY_POSITION('hello'::variant, array_construct('hola', 'bonjour'));
+----------------------------------------------------------------------+
| ARRAY_POSITION('HELLO'::VARIANT, ARRAY_CONSTRUCT('HOLA', 'BONJOUR')) |
|----------------------------------------------------------------------|
|                                                                 NULL |
+----------------------------------------------------------------------+

Copy

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4