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 votes216 views1 answer
Mysql select default if null
SQL
5 votes208 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote194 views1 answer
Groupby error in mysql
SQL
2 votes207 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
1 vote198 views3 answers
Mysql disable foreign keys check
SQL
1 vote213 views1 answer
Increase existing date in sql
SQL
0 vote259 views2 answers
How to truncate all table in mysql workbench
SQL
2 votes203 views1 answer
Sql update from different table
SQL
0 vote197 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
4 votes197 views2 answers
Sql table
SQL