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

16 votes189 views1 answer
Mysql mediumint max value
SQL
0 vote270 views2 answers
Disadvantages of stored procedures sql
SQL
0 vote151 views1 answer
Get last run query sql server
SQL
13 votes179 views6 answers
Mysql update from select
SQL
0 vote180 views1 answer
Create table Statement Syntax in SQL Server
SQL
0 vote178 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
0 vote187 views1 answer
Mysql query problems and solutions
SQL
0 vote181 views1 answer
Longtext sql
SQL
4 votes204 views1 answer
Is there any command to change postgres password
SQL
22 votes220 views3 answers
Sql cheat sheet
SQL