RDBMS_PRACT_6_D

Assignment 6 Exception Handling : SET D

create or replace function f5(b int,dt date)returns text as'

declare rec record;

name driver.dname%type;

begin

for rec in select * from bd

loop

if(rec.bno<>b)then

raise notice''invalid'';

else select dname into name from driver where dno in(select dno from bd where bno=b and duty_date=dt);

end if;

end loop;

raise notice ''driver name=%'',name;

return '' '';

end'

language 'plpgsql';

CREATE FUNCTION

buss4=# select * from bd;

 bno | dno | duty_date  | shift

-----+----+-----------+------

  22 |   2 | 2009-04-03 | e

  33 |   3 | 2009-03-03 | m

(2 rows)

buss4=# select f5(22,'2009-04-03');

NOTICE:  invalid

NOTICE:  driver name=vidya

 f5

----

 

(1 row)