Advertisement
joshuaboshi

Untitled

Aug 19th, 2011
179
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE OR REPLACE FUNCTION sch."proc"(pid integer, pfrom character varying, pto character varying)
  2.   RETURNS void AS
  3. $BODY$
  4. declare
  5.     upd record;
  6. begin
  7.    
  8.     SELECT * INTO upd FROM sch."Tbl" WHERE id = pid and pname = pfrom;
  9.     IF NOT FOUND THEN
  10.         RAISE EXCEPTION 'No item found with id % and name %. Quitting.', pid, pfrom;
  11.     ELSE
  12.         RAISE NOTICE 'Item found, everythink ok';
  13.     END IF;
  14.  
  15.     upd.name := pto;
  16.    
  17.     insert into server."Tbl" select (upd).*;
  18.    
  19. end
  20. $BODY$
  21.   LANGUAGE plpgsql VOLATILE
  22.   COST 100;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement