44JR5

PostgreSQL SQL dialect Expires in: 6 days, 17 hours
Delete Now
Raw
Slim

Copy Snippet
Edit Snippet
Wordwrap

CREATE FUNCTION usp_set_foo_bar(i_id bigint)
RETURNS void
LANGUAGE sql
AS $function$
UPDATE foo SET a = a + 1 WHERE id = i_id;
UPDATE bar SET b = b + 1 WHERE id = i_id;
$function$
;

Edit this Snippet

Syntax

Expires

Right-to-Left

Content CREATE FUNCTION usp_set_foo_bar(i_id bigint) RETURNS void LANGUAGE sql AS $function$ UPDATE foo SET a = a + 1 WHERE id = i_id; UPDATE bar SET b = b + 1 WHERE id = i_id; $function$ ;