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

0 vote197 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
20 votes205 views6 answers
Change password in mysql
SQL
4 votes198 views1 answer
Restart for pg_hba.conf file
SQL
3 votes201 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote198 views1 answer
Psotgres multiple values
SQL
13 votes207 views3 answers
Uninstall mysql centos 7
SQL
1 vote186 views1 answer
Sql avg group by
SQL
0 vote201 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote232 views1 answer
Oracle decode
SQL
1 vote212 views1 answer
Median mysql
SQL