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 vote302 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
4 votes328 views2 answers
Oracle unlock account
SQL
1 vote283 views1 answer
Mysql find tables with column name
SQL
5 votes319 views2 answers
Oracle list columns
SQL
1 vote297 views3 answers
Grant syntax in sql
SQL
0 vote336 views1 answer
Python mysql show databases
SQL
0 vote314 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
11 votes328 views3 answers
How to get last row of table in sql
SQL
11 votes313 views2 answers
Insert date sql
SQL
1 vote346 views1 answer
Alter database datafile maxsize 32g
SQL