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

1 vote191 views1 answer
SQLite order random
SQL
2 votes188 views2 answers
Oracle no data found error code
SQL
0 vote199 views2 answers
Postgresql variable in query
SQL
0 vote269 views2 answers
Install phoenix
SQL
0 vote197 views1 answer
Write SQL in ruby on rails
SQL
3 votes284 views2 answers
Savepoint in sql
SQL
0 vote270 views1 answer
How to make full text search dynamic in mysql
SQL
0 vote194 views1 answer
Asp.net core sql server stored procedure
SQL
0 vote193 views1 answer
Enable Rabbitmq management plugin
SQL
0 vote177 views1 answer
Tsql generate rows
SQL