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 vote209 views1 answer
Drop domain postgresql
SQL
0 vote163 views1 answer
Sql show all users
SQL
1 vote230 views1 answer
Mysql show database size in mb
SQL
4 votes169 views1 answer
Mysql ip address
SQL
9 votes183 views2 answers
Sql server check table exists
SQL
33 votes156 views2 answers
Postgres how to add field created at
SQL
0 vote168 views1 answer
Mysql max number not returning correct value
SQL
7 votes186 views5 answers
Max 3 salary in sql
SQL
0 vote171 views1 answer
How to get specific salary in sql
SQL
2 votes158 views2 answers
Function in sql
SQL