PostgreSQL – JSON_BUILD_ARRAY Function

ByAdmin

The json_build_array function in PostgreSQL is used to create a JSON array from a list of values. It takes any number of arguments and returns a JSON array containing those values. Each argument will be treated as an element of the resulting JSON array.

Below is the basic syntax of using the json_build_array function:

json_build_array(value1, value2, ..., valueN)

Here’s an example of using json_build_array:

SELECT json_build_array('apple', 42, true);

This query would return a JSON array:

json_build_array 
------------------------ 
["apple", 42, true]

You can also use expressions or columns as arguments to json_build_array:

SELECT json_build_array(first_name, last_name) FROM employees;

This would create a JSON array for each row in the employees table, containing the values from the first_name and last_name columns.

Similar Posts

PostgreSQL – JSON_EXTRACT_PATH_TEXT Function

ByAdmin

The json_extract_path_text function is used to extract a specific value from a JSON object or array by specifying a path to the desired element. This function returns the value as text. The basic syntax of the json_extract_path_text function is as shown below: json_extract_path_text(json_object_or_array, path_element1, path_element2, …, path_elementN) Here’s an example of using the json_extract_path_text function:…