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 vote194 views1 answer
Java mysql swing example
SQL
1 vote189 views1 answer
What is a Database?
SQL
0 vote194 views1 answer
Mysql foreach insert
SQL
2 votes181 views1 answer
Mysql sysdate
SQL
0 vote196 views1 answer
Mysql order by rand limit 1 really slow
SQL
4 votes221 views1 answer
Mysql set max connections
SQL
0 vote282 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote198 views1 answer
How to put value in parameters in mysqldataadapter
SQL
0 vote182 views1 answer
Check index sql server
SQL
0 vote265 views1 answer
Restart serial number for postgres
SQL