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 vote342 views1 answer
Sql insert exemplo
SQL
1 vote243 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
2 votes245 views2 answers
Mysql on duplicate key update get value from values
SQL
0 vote243 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
0 vote255 views1 answer
Repeatable read trong sql server
SQL
0 vote243 views1 answer
Find usage of table in sql server
SQL
0 vote241 views1 answer
Mysql dump everythign
SQL
26 votes226 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote228 views1 answer
Sql select first and last record of each group
SQL
0 vote235 views1 answer
MySQL - How to find word with the most similar beginning
SQL