PostgreSQL is capable of executing server-side code. There are many ways to provide PostgreSQL with the code to be executed. For example, the user can create functions in different programming languages. The main languages supported by PostgreSQL are as follows:
- SQL
- PL/pgSQL
- C
These listed languages are the built-in languages; there are also other languages that PostgreSQL can manage, but before using them, we need to install them on our system. Some of these other supported languages are as follows:
- PL/Python
- PL/Perl
- PL/tcl
- PL/Java
In this section, we'll talk about SQL and PL/pgSQL functions.
Functions
The command structure with which a function is defined is as follows:
CREATE FUNCTION function_name(p1 type, p2 type,p3 type, ....., pn type)
RETURNS type AS
BEGIN
-- function logic
END;
LANGUAGE language_name
The following steps always apply for any type of function we want to create:
- Specify the name of the function...