sql
create function increment (x int, row_id int) 
returns void as
$$
  update table_name 
  set field_name = field_name + x
  where id = row_id
$$ 
language sql volatile;

js
const { data, error } = await supabase
  .rpc('increment', { x: 1, row_id: 2 })

hey, ik i can increment a field like this but is there a way i can dynamically increment a field? like provide the column name through the rpc?

If I had to guess it it would be something like

sql
create function increment (schema text, "table" text, "column" text, filter_column text,
filter_value text) 
RETURNS VOID AS
$$
BEGIN
    execute format('UPDATE %I.%I SET %I = %I + 1 WHERE %I = %L,
                                schema,
                                "table",
                                "column",                 "column",
                                filter_column, filter_value'
        );
END;
$$ language plpgsql;

im not familiar with plpgsql, how would i call the rpc for this?

I missed the first line of the definition

yeah thatd be great

I wasn't too far off

sql

 create or replace function increment (schema text, "table" text, "column" text, filter_column text,
filter_value text) 
RETURNS VOID AS
$$
BEGIN
    execute format('UPDATE %I.%I SET %I = %I + 1 WHERE %I = %L',
                                schema,
                                "table",
                                "column",
                                "column",
                                filter_column, 
                                filter_value
        );
END;
$$ language plpgsql;

create table increment_test (
id int,
price int
);

insert into increment_test (id, price)
values 
(1, 67),
(6, 54);

-- public is just the default schema
select public.increment('public', 'increment_test', 'price', 'id', '6');

select * from increment_test

ah ok, this is great thanks

no worries

sql
create or replace function increment ("column" text, filter_value text) 
RETURNS RECORD AS
$$
BEGIN
    execute format('UPDATE public.user_cards SET %I = %I + 1 WHERE uuid = %L SET stat_pts = stat_pts - 1 WHERE uuid = %L',
                                "column",
                                "column",
                                filter_value
        );
END;
$$ language plpgsql;

hey sorry to bother you again. i was trying to modify the function you gave me but supabase says i have a syntax error somewhere?

You may need to

return query execute

I removed that to suite the void as you had as it was simpler. Also if will need to have

returning *

as the last part of the update statement and then that will return the contents of the row.