© 2026 Hedgehog Software, LLC

More

Communities Docs About Terms Privacy

Supabase•4y ago•

4 replies

Insert 3 rows at once

How to insert 3 rows at once via a trigger
using the values 3 times does not work

begin
  insert into public.reactioncount(parent_id, reaction_value)
  values(new.id, 'share');
  values(new.id, 'comment');
  values(new.id, 'like');
  return new;
end;

begin
  insert into public.reactioncount(parent_id, reaction_value)
  values(new.id, 'share');
  values(new.id, 'comment');
  values(new.id, 'like');
  return new;
end;