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 vote315 views1 answer
Tsql find procedure with name
SQL
0 vote313 views1 answer
Find invalid datetime field
SQL
1 vote306 views1 answer
Select from one table where not on the other
SQL
0 vote306 views1 answer
Mysql remove tabs from string
SQL
0 vote367 views1 answer
Postgresql alter table sequence
SQL
0 vote388 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
19 votes317 views6 answers
Sql create table
SQL
0 vote334 views1 answer
Postgresql linux password
SQL
12 votes300 views2 answers
Delete all data in neo4j
SQL
0 vote329 views1 answer
Add a new column into table
SQL