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

4 votes286 views2 answers
Mysql select where starts with
SQL
0 vote248 views1 answer
Java spring boot connect to sql server
SQL
4 votes340 views2 answers
Postgresql float data type
SQL
0 vote254 views1 answer
Kannst du deine finger trainieren
SQL
0 vote282 views1 answer
Postgresql update to unique
SQL
1 vote304 views3 answers
Get all tables postgres
SQL
0 vote284 views1 answer
Postgres truncate with cascade
SQL
0 vote274 views1 answer
Parsing float to int in mysql
SQL
0 vote327 views1 answer
Mysql grant all on all databases
SQL
17 votes306 views4 answers
Sort by mysql
SQL