PostgreSQL provides a set of powerful, embedded languages. Because PostgreSQL can easily be extended, it is an easy task to add new languages to the server. PL/pgSQL is a block-oriented language you can use to write your own extensions to PostgreSQL. In many aspects PL/pgSQL is similar to Oracle's PL/SQL, but there are also some major differences. Writing triggers is an easy task when using PL/pgSQL. Triggers can be used to perform certain tasks in your database automatically and are supported by almost all sophisticated databases. |