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 vote111 views1 answer
Where in clause tsql
SQL
0 vote126 views1 answer
Update view sql
SQL
0 vote146 views1 answer
Select count concat string sql server
SQL
4 votes118 views1 answer
Oracle error compilation line
SQL
0 vote115 views1 answer
Test connection to sql server
SQL
0 vote133 views1 answer
Mysql drop vs delete
SQL
0 vote138 views1 answer
Sql server current time without date
SQL
23 votes144 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote158 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
1 vote204 views1 answer
Mysql breakline on string
SQL