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

3 votes201 views2 answers
WhereIn SQL
SQL
0 vote128 views1 answer
Ms sql print more than 1 variable
SQL
0 vote192 views1 answer
Mysql replication change database name
SQL
0 vote191 views1 answer
Postgresql array to rows
SQL
0 vote190 views1 answer
Laravel migration sql dump
SQL
0 vote166 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
2 votes183 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote243 views1 answer
Suhaib
SQL
1 vote175 views1 answer
Mysql current time
SQL
1 vote180 views1 answer
DATE_SUB postgres
SQL