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

6 votes160 views2 answers
Postgresql pg_dump
SQL
1 vote148 views1 answer
Show indices in mysql table
SQL
0 vote135 views1 answer
Ms Sql set us timezone
SQL
0 vote153 views1 answer
Oracle procedure teamplate
SQL
3 votes231 views2 answers
Savepoint in sql
SQL
0 vote151 views1 answer
Sql script to remove default from column
SQL
0 vote137 views1 answer
Transalations from sql to Linq count and group by
SQL
3 votes150 views2 answers
Get current year sql
SQL
4 votes146 views2 answers
Postgre sql create table
SQL
50 votes236 views6 answers
Install mysql on ubuntu
SQL