© 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_5

5. Control Statements

Baji Shaik1   and Dinesh Kumar Chemuduru2
(1)
Texas, TX, USA
(2)
Andhra Pradesh, India
 

In the previous chapter, we talked about strings, numbers, and arrays and how to use them in PL/pgSQL programming. We walked through the use cases and examples to deal with strings, numbers, and arrays. This chapter provides an in-depth guide to the different types of control statements and their usage in the PL/pgSQL programming language. This chapter covers a range of control statements, including IF, CASE, LOOP, WHILE, FOR, and FOREACH ...

Get Procedural Programming with PostgreSQL PL/pgSQL: Design Complex Database-Centric Applications with PL/pgSQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.