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 vote219 views1 answer
How to delete duplicate rows in oracle
SQL
4 votes231 views6 answers
Select sql
SQL
1 vote206 views1 answer
Backup mysql data only
SQL
0 vote243 views1 answer
How to get table id sequence postgres
SQL
0 vote193 views1 answer
Sql transact create cursor with dynamic tables
SQL
1 vote210 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote227 views1 answer
Delete hangfire retries list
SQL
-2 votes222 views2 answers
Union all in sql
SQL
0 vote656 views1 answer
Mysql custom sort order
SQL
3 votes208 views1 answer
Ssh check mysql version
SQL