- DECLARE (Optional)
- Variables,
- cursors,
- BEGIN (Mandatory)
- SQL statements
- PLPGSQL statements
- EXCEPTION (Optional)
- Actions to perform when errors occur
- END; (Mandatory)
- All key words and identifiers can be written in mixed upper and lower case. Identifiers are implicitly converted to lowercase unless doublequoted.
- There are two types of comments in PL/pgSQL.
- -- starts a comment that extends to the end of the line.
- /* multi-line comments */
No comments:
Post a Comment