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

8 votes190 views1 answer
Oracle current date plus 1 month
SQL
-1 vote201 views1 answer
Search all database tables for a value sqlserver
SQL
0 vote197 views2 answers
Execute stored procedure without db set
SQL
2 votes190 views1 answer
Q operator in sql
SQL
-1 vote166 views2 answers
On delete set default sql server
SQL
0 vote196 views1 answer
Createdb with postgresql on ubuntu
SQL
10 votes192 views1 answer
Oracle all_dependencies
SQL
0 vote193 views1 answer
Sql recherche nom prenom
SQL
16 votes210 views4 answers
Ascending order mysql
SQL
3 votes274 views1 answer
Oracle cannot access v$session
SQL