CREATING ENTERPRISE SYSTEM USING POSTGRESQL (part 2)

Create function and store procedure using PL/pgsql

create function

create function trade.f_login( u varchar(20) , p varchar(20) ) returns
varchar(20)
as
$$
DECLARE
temp1 varchar(20) ;
BEGIN
select temp1 = usr_name || usr_Section from trade.t_m_user
where usr_Code = $1 and usr_password = $2;
return temp1 ;
END ;
$$language 'plpgsql';
select trade.f_login( 'Kebo','Uler' );

create Procedure

create function trade.In_tm_Code ( u varchar(20) , p varchar(20) )
as
$$
BEGIN
insert into trade.t_m_code values( $1 , $2);

END ;

$$language 'plpgsql';

perform trade.In_tm_Code( 'Kebo','Uler' );