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

4 votes176 views1 answer
Oracle delete last row
SQL
0 vote176 views1 answer
Can sqldatareader be null
SQL
1 vote212 views1 answer
Oracle drop temporary table
SQL
0 vote144 views1 answer
Procedures and functions in pl/sql
SQL
0 vote182 views1 answer
Date datatype in livesql
SQL
0 vote162 views2 answers
Mysql slave status
SQL
6 votes163 views1 answer
Rank function in oracle with example
SQL
0 vote185 views1 answer
Allow null in psql
SQL
0 vote167 views1 answer
Pass array parameter to stored procedure c#
SQL
21 votes171 views3 answers
Average sql
SQL