Writing Stored Procedures
In Chapter 6, Optimizing Queries for Good Performance, we learned a lot about the optimizer, as well as the optimizations going on in the system. In this chapter, we will learn about stored procedures and how to use them efficiently and easily. You will learn about what a stored procedure is made up of, which languages are available, and how you can speed things up nicely. On top of that, you will be introduced to some of the more advanced features of PL/pgSQL, and you will learn how to write good server-side code.
The following topics will be covered in this chapter:
- Understanding stored procedure languages
- Exploring various stored procedure languages
- Improving functions
- Using functions for various purposes
By the end of this chapter, you will be able to write good, efficient stored procedures.
