© 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 Shaik1   and Dinesh Kumar Chemuduru2
Texas, TX, USA
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 ...

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.