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;
returnnull; END;'LANGUAGE 'plpgsql';
Looking forward for suggestions. Thanks
Prasad.
