nn
Size: a a a
nn
nn
nn
CREATE FUNCTION public.organisations_after_insert_delete_row_tr() RETURNS trigger
LANGUAGE plpgsql
AS $$
BEGIN
UPDATE organisations
SET sequential_id = t.next_seq_id
FROM (
SELECT id, row_number() OVER (ORDER BY created_at ASC) as next_seq_id
FROM organisations
) t
WHERE t.id = organisations.id;
RETURN NULL;
END;
$$;
nn
nn
O
nn
O
O
nn
nn
nn
nn
nn
O
O
nn
nn
nn