PL/pgSQL Variables
Baji Shaik, Dinesh Kumar Chemuduru · Apress eBooks · 2023
In the previous chapter, we talked about what PL/pgSQL is and some use cases where you need it. We also explained the steps to install and the execution flow of PL/pgSQL with a simple diagram. We have discussed some PL/pgSQL anonymous and named code block examples which will help in understanding the basics. In this chapter, we will introduce variables that are used in the PL/pgSQL code. We will provide different types of variables and use cases on when to use them. We will show the declaration and scope of variables and different types of variables with some examples.