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)

No comments:

Post a Comment