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_14

14. Handling Exceptions

Baji Shaik¹   and Dinesh Kumar Chemuduru²

(1)

Texas, TX, USA

(2)

Andhra Pradesh, India

 

In the previous chapter, we talked about returning complex data types, arrays, and record types from PL/PGSQL functions and procedures and explored output parameters for returning multiple values. In this chapter, we will cover different types of exceptions in PostgreSQL. It will start with the introduction of exceptions and how to use them within PL/pgSQL code with a simple example. We will walk through some real-world examples of where ...