Hi,

 

 I have been trying to figure out why this simple query doesn't execute if no record exist !

 

CREATE OR REPLACE FUNCTION del_rest() RETURNS TRIGGER AS '
DECLARE
    t record;
  BEGIN
      SELECT * INTO t FROM del2 WHERE (d2=OLD.d2 or old.d2 is null) and (d3=OLD.d3 or  old.d2 is null);
         IF NOT FOUND THEN
           RAISE NOTICE ''No such record exits in table del2'';
         END IF;
          return null;  
   END;
'LANGUAGE 'plpgsql';

 

Looking forward for suggestions. Thanks

 

Prasad.