Postgresql functions

Create function in postgresql

create [or replace] function function_name(param_list)
   returns return_type 
   language plpgsql
as $$
declare 
-- variable declaration
begin
 -- logic
end;
$$

Source: postgresqltutorial.com

Similar codes

0 vote203 views1 answer
Is not null postgresql
SQL
5 votes206 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote213 views1 answer
Convert rows into columns in oracle
SQL
9 votes240 views6 answers
Check constraint in sql
SQL
0 vote199 views1 answer
How to install Firebird
SQL
0 vote273 views2 answers
How to check if a column exists in a SQL Server table?
SQL
11 votes218 views1 answer
Ddl materialized view
SQL
2 votes181 views2 answers
Mysql get last character of string
SQL
0 vote209 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
2 votes214 views1 answer
Alter table add multiple columns postgresql
SQL