Breaking News: Grepper is joining You.com. Read the official announcement!

create function in postgresql

Powerful Pheasant answered on October 16, 2020 Popularity 10/10 Helpfulness 6/10

answer create function in postgresql

create function in postgresql

Comment

create [or replace] function function_name(param_list)
   returns return_type 
   language plpgsql
as $$
declare 
-- variable declaration
begin
 -- logic
end;
$$

Popularity 10/10 Helpfulness 6/10 Language sql

Source: www.postgresqltutorial.com

Tags: create-function postgresql sql

Link to this answer
Share Copy Link

Contributed on Oct 16 2020

Powerful Pheasant

0 Answers Avg Quality 2/10

Closely Related Answers

function in postgresql

Comment

CREATE OR REPLACE FUNCTION totalRecords ()
RETURNS integer AS $total$
declare
	total integer;
BEGIN
   SELECT count(*) into total FROM COMPANY;
   RETURN total;
END;
$total$ LANGUAGE plpgsql;

Popularity 10/10 Helpfulness 4/10 Language sql

Source: www.tutorialspoint.com

Tags: function functio

Link to this answer
Share Copy Link

Contributed on Jul 05 2022

Itchy Ibis

0 Answers Avg Quality 2/10

postgresql function

Comment

Create or replace Function public.my_function(p_el1 int, p_el2 int, p_name char)
Returns table (id int, price int)
language plpgsql

as
$$
	declare
		v_total int;
	
	begin
		-- insert into first table
		insert into my_table1
			(added_name)
		values
			(p_name);

		-- Insert the result of a calculation in a variable
		select (p_el1 + p_el2) into v_total;
	
		-- Update a second table
		update my_table2 mt
		set
			price = v_total
		where
			mt.name = p_name;
		
		-- Return the result of a query
		return query (select
							mt.id,
							mt.price
						from
							my_table2 mt
						where
							mt.name = p_name);
		
	end;
$$

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: function functio

Link to this answer
Share Copy Link

Contributed on May 31 2022

Puzzled Penguin

0 Answers Avg Quality 2/10

create function postgresql

Comment

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;

Popularity 10/10 Helpfulness 4/10 Language sql

Source: www.tutorialspoint.com

Tags: create-function

Link to this answer
Share Copy Link

Contributed on Nov 09 2021

Good Gharial

0 Answers Avg Quality 2/10

create function in postgresql

Contents

More Related Answers

create function in postgresql

Closely Related Answers

function in postgresql

postgresql function

create function postgresql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.