Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DO $$
- DECLARE
- linhas INTEGER;
- BEGIN
- UPDATE tabela
- SET valor = 'valor';
- IF NOT FOUND THEN
- RAISE NOTICE'Nenhuma linha encontrada %';
- ELSIF FOUND THEN
- GET DIAGNOSTICS linhas := ROW_COUNT;
- RAISE NOTICE'Linhas afetadas: %', linhas;
- END IF;
- END $$;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement