//
Search across all documentation pages
9 pages in this section.
How PL/pgSQL's block structure, volatility markers, and function-versus- procedure split actually shape planner behavior, not just the syntax for writing them.
Learn to create and use basic and intermediate SQL and PL/pgSQL functions with 9 practical examples, covering syntax and usage.
Learn PL/pgSQL essentials: variables, control flow, and the FOUND variable. Implement robust PostgreSQL functions and avoid common pitfalls.
Learn to implement and review PostgreSQL stored procedures using the CALL statement. Understand best practices, common pitfalls, and alternatives for OLTP workloads.
Understand PostgreSQL function volatility (IMMUTABLE, STABLE, VOLATILE) and its impact on query planning and performance.
Learn best practices for designing, securing, and testing PostgreSQL functions. Optimize performance, manage security, and ensure reliable database logic.
A single-page roundup of every highlight bullet from the 8 pages in the Functions & PL/pgSQL section, grouped by source page so you can scan all 41 takeaways without opening each article individually.