In the previous chapter, we talked about Dynamic SQL and how to create and use them in PL/pgSQL with real time use cases. In this chapter, we will discuss functions and procedures in PostgreSQL and how to build them using the PL/pgSQL programming language. We will cover the different types of available function categories and differences between them using some examples. It will help to choose the function category while ...
© 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_1212. Building Functions and Procedures
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.
