PostgreSQL: The definitive guide
PrevNext

IV. Programming with PostgreSQL

Table of Contents
11. PL/pgSQL
11.1. Adding PL/pgSQL to your Database
11.1.1. Adding PL/pgSQL to your Database
11.2. Language Structure
11.2.1. Code Blocks
11.2.2. Comments
11.2.3. Statements and Expressions
11.3. Using Variables
11.3.1. Data types
11.3.2. Declaration
11.3.3. Assignment
11.3.4. Argument Variables
11.3.5. Returning Variables
11.3.6. Attributes
11.3.7. Concatenation
11.4. Controlling Program Flow
11.4.1. Conditional statements
11.4.2. Loops
11.4.3. Handling Errors and Exceptions
11.4.4. Calling Functions
11.5. PL/pgSQL and Triggers
12. JDBC
12.1. Building the PostgreSQL JDBC Driver
12.2. Using the PostgreSQL Driver
12.3. Using JDBC
12.3.1. Basic JDBC Usage
12.3.2. Using Advanced JDBC Features
12.4. Issues Specific to PostgreSQL and JDBC
PrevHomeNext
Granting Privileges PL/pgSQL