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 vote356 views1 answer
Default value false mysql
SQL
0 vote365 views1 answer
Postgresql show owner of database
SQL
0 vote338 views2 answers
Plsql function that return a table
SQL
0 vote310 views2 answers
How to combine two sql queries in one result
SQL
5 votes348 views1 answer
Ascending order and where in sql
SQL
19 votes331 views1 answer
Sqrt(-1)
SQL
0 vote355 views1 answer
Query on date sqlite flutter
SQL
-1 vote365 views3 answers
Compute age mysql
SQL
5 votes329 views1 answer
Mysql select greater than yesterday
SQL
-1 vote336 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL