Create function postgresql

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

Similar codes

25 votes102 views6 answers
Import mysql database command line
SQL
0 vote90 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote56 views1 answer
Mysql convert column to uppercase
SQL
4 votes65 views2 answers
Create table if not exists postgres
SQL
0 vote134 views1 answer
SQL Where-Klausel
SQL
16 votes121 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
0 vote70 views2 answers
Sql update from two different database
SQL
2 votes97 views1 answer
Match in sql server
SQL
1 vote101 views1 answer
Oracle convert run duration to number
SQL
1 vote270 views2 answers
Coderbyte sql solutions
SQL