Building Functions and Procedures
Baji Shaik, Dinesh Kumar Chemuduru · Apress eBooks · 2023
In the previous chapter, we talked about arrays and how to use them in PL/pgSQL with some examples. 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 developing. We will also explain the different types of procedures and how to use them with some examples.