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 ...
2. PL/pgSQL Variables
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.