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 vote266 views1 answer
Mysql show category once count how many products
SQL
0 vote285 views1 answer
Get clob size oracle
SQL
0 vote254 views2 answers
Mysql disable foreign key checks
SQL
1 vote266 views1 answer
Postgres convert date to string
SQL
0 vote271 views1 answer
Sql dmv to capture updates
SQL
1 vote288 views1 answer
Sql server if exists update else insert
SQL
5 votes277 views5 answers
Sqlite install python
SQL
0 vote276 views1 answer
Create function in microsoft sql server
SQL
0 vote277 views1 answer
Oracle locked objects
SQL
0 vote265 views1 answer
Do you know sql
SQL