Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION sch."proc"(pid integer, pfrom character varying, pto character varying)
- RETURNS void AS
- $BODY$
- declare
- upd record;
- begin
- SELECT * INTO upd FROM sch."Tbl" WHERE id = pid and pname = pfrom;
- IF NOT FOUND THEN
- RAISE EXCEPTION 'No item found with id % and name %. Quitting.', pid, pfrom;
- ELSE
- RAISE NOTICE 'Item found, everythink ok';
- END IF;
- upd.name := pto;
- insert into server."Tbl" select (upd).*;
- end
- $BODY$
- LANGUAGE plpgsql VOLATILE
- COST 100;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement