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

13. Return Values and Parameters

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

In the previous chapter, we talked about building functions and procedures. We covered examples of using IMMUTABLE, STABLE and VOLATILE functions besides to temporary functions and variadic functions. In this chapter, we will cover the importance of returning a value in a function and the different types of options available to return the values in PL/pgSQL. We will walk through some real-world examples of where and when to use ...

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.