PostgreSQL – ARRAY_POSITION Function

ByAdmin

ARRAY_POSITION function in PostgreSQL is used to return the position of the first occurrence of an array element.

Here is the basic syntax of using array_position function.

SELECT  array_position(your_array_column, int)) AS position 
FROM your_table ;

Example of using array_position function:

SELECT array_position(array(20, 10, 10, 30), 10) AS position;

The output would be 2 ; as 10 is in the second position and third position. However, the first occurrence of 10 is in the second position.

Similar Posts

PostgreSQL – ARRAY_TO_STRING Function

ByAdmin

The array_to_string function is used to convert an array of elements into a single string in PostgreSQL database by concatenating the elements together with a specified delimiter. Here is the syntax for the array_to_string function: array_to_string(array_expression, delimiter) where array_expression is the array that you want to convert into a string. and delimiter is the delimiter…

PostgreSQL – STRING_TO_ARRAY Function

ByAdmin

The string_to_array function is used to split a string into an array of substrings based on a specified delimiter. It takes a string as input and returns an array of text elements as output. Below is the syntax for the string_to_array function: string_to_array(input_string, delimiter) where input_string is the string that you want to split into…