Procedural Programming with PostgreSQL PL/pgSQL: Design Complex Database-Centric Applications with PL/pgSQL

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

B. Shaik, D. K. ChemuduruProcedural Programming with PostgreSQL PL/pgSQLhttps://doi.org/10.1007/978-1-4842-9840-4_6

6. Handling Arrays

Baji Shaik¹   and Dinesh Kumar Chemuduru²

(1)

Texas, TX, USA

(2)

Andhra Pradesh, India

 

In the previous chapter, we talked about control statements in PL/pgSQL of PostgreSQL. We covered some examples of IF ELSE, CASE statements and some iterative statements like LOOP, WHILE, FOR and FOREACH. In this chapter, we will dive deep into arrays. We will cover array index and array length, use foreach to iterate over the arrays, and convert arrays to a set of rows. It will also include finding duplicate elements in an array, appending ...