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 vote189 views1 answer
Select all tables linked server sql
SQL
0 vote249 views1 answer
Mysql grant user wildcard database
SQL
4 votes264 views2 answers
DB::transaction
SQL
2 votes198 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote206 views1 answer
Narural join
SQL
0 vote230 views1 answer
Delete first row in sql
SQL
33 votes203 views6 answers
Change column name in mysql
SQL
0 vote193 views1 answer
Renombrar tabla mysql
SQL
6 votes198 views1 answer
Sqlite foreign key
SQL
0 vote233 views1 answer
Postgres docs /copy metacomand
SQL