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 vote330 views2 answers
Sql day from datetime
SQL
1 vote313 views1 answer
Mysql show database size in mb
SQL
0 vote310 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
0 vote325 views1 answer
Sql get latest of 2 datetimes
SQL
3 votes308 views2 answers
Sql select data from last week
SQL
0 vote291 views1 answer
Sort by last two number sql
SQL
7 votes311 views2 answers
Execute mysql file
SQL
2 votes294 views1 answer
Enum in SQL Server
SQL
1 vote301 views1 answer
Mysql sort by date column
SQL
0 vote315 views1 answer
Sql examples from framework
SQL