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

37 votes128 views3 answers
Postgresql insert column
SQL
0 vote138 views2 answers
How to drop mili second in sql
SQL
0 vote156 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
17 votes139 views3 answers
How to change a collumn name in sql
SQL
7 votes124 views3 answers
Postgresql dump and restore db
SQL
1 vote136 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
6 votes162 views1 answer
Check Table Exists
SQL
0 vote126 views1 answer
Postpresql relation not found
SQL
0 vote137 views1 answer
Get the next column of a table in mysql
SQL
-1 vote128 views1 answer
What is in operator
SQL