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

5 votes120 views2 answers
To date oracle
SQL
1 vote104 views1 answer
Delete mysql from mac
SQL
1 vote160 views1 answer
Oracle datafile max size 32gb
SQL
-1 vote112 views1 answer
Count occurrences sql
SQL
1 vote103 views1 answer
Apex ORA-20999
SQL
0 vote101 views1 answer
Sqlite3 now
SQL
1 vote108 views6 answers
In sql
SQL
1 vote96 views1 answer
Foreign key constraint in ms sql
SQL
11 votes118 views2 answers
How to import mysql database command line
SQL
4 votes103 views1 answer
Force drop all tables postgres
SQL