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

-1 vote343 views1 answer
Sql getdate date only
SQL
0 vote312 views1 answer
Delete all rows from table sqlite
SQL
4 votes351 views1 answer
Sql delete where in select
SQL
1 vote348 views1 answer
Column with prefix in sql
SQL
3 votes366 views2 answers
Sql select data from last week
SQL
12 votes351 views2 answers
Delete entries in postgresql
SQL
1 vote378 views1 answer
Select last row from SQL Table
SQL
0 vote421 views1 answer
Drop view in mysql
SQL
5 votes392 views1 answer
Mysql add user with all privileges
SQL
0 vote346 views1 answer
Add alternate add column sql
SQL