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

2 votes135 views1 answer
Mysql sysdate - 1 day
SQL
1 vote97 views2 answers
Procedure pl/sql
SQL
1 vote156 views2 answers
Mysql add column tinyint default 0
SQL
1 vote151 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
1 vote148 views1 answer
How to see which columns are indexxed mysql
SQL
1 vote126 views1 answer
Rows to comma separated values in mssql
SQL
1 vote141 views1 answer
Rermove categories woocommerce sql
SQL
1 vote130 views1 answer
Cross schema query oracle 2 users
SQL
0 vote138 views1 answer
Download sql file of countries names
SQL
0 vote132 views1 answer
Number(10 2) in sql means
SQL