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

Create function postgresql

CREATE OR REPLACE FUNCTION auditlogfunc() RETURNS TRIGGER AS $example_table$
   BEGIN
      INSERT INTO AUDIT(EMP_ID, ENTRY_DATE) VALUES (new.ID, current_timestamp);
      RETURN NEW;
   END;
$example_table$ LANGUAGE plpgsql;

Source: tutorialspoint.com

Plpgsql create function

postgres=# Create or replace function fun1(n int) returns int 

as

$$

Begin

Insert into test values (n,'2019-11-26');

Return 1;

End;

$$

Language 'plpgsql';

CREATE FUNCTION

postgres=#

Source: enterprisedb.com

Similar codes

1 vote129 views1 answer
Convert to hexadecimal sql
SQL
37 votes117 views3 answers
Postgresql insert column
SQL
23 votes126 views6 answers
Create table sql server
SQL
14 votes114 views2 answers
Oracle add column with default value
SQL
0 vote118 views1 answer
Compare subqueries oracle
SQL
0 vote115 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote110 views1 answer
C# mysql data reader from two tables
SQL
1 vote131 views1 answer
Load mysql dumb
SQL
18 votes119 views6 answers
Create table mysql
SQL
-1 vote126 views1 answer
How to dump .csv file into mysql
SQL