Amazon Redshift
Database Developer Guide

PL/pgSQL Language Reference

Stored procedures in Amazon Redshift are based on the PostgreSQL PL/pgSQL procedural language, with some important differences. In this reference, you can find details of PL/pgSQL syntax as implemented by Amazon Redshift. For more information about PL/pgSQL, see PL/pgSQL - SQL Procedural Language in the PostgreSQL 8.0 documentation.