Hey guys, I've been trying to run this code in my SQL editor and haven't gotten updates on my table to work. Can anyone help point out what's wrong?

CREATE OR REPLACE FUNCTION public.test_fn(row_id bigint) RETURNS void AS $$
    UPDATE restaurants SET name = 'test'
    WHERE row_id = 36;
$$ language sql volatile;

Hello @rockinbinbin! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

I've already disabled RLS on this

restaurants

table so that I can focus on getting the update working.

You need to add

BEGIN

and

END

around your function code I believe. I'd guess you're getting an error. First step to troubleshooting would be to

const { data, error } = await supabase.rpc("test_fn")

and

console.log({ error })

rockinbinbin (2022-03-25)

can you give me an example?

SQL language function won't work with Begin/End. Function seems fine I just ran it on a table I have. Can you run it from the sql window?

I've been running it in the SQL editor and it says success but the table column doesn't update

is row_id a bigint?

yeah but i'm not even using it

Is your column name row_id?

column name is actually id that was a mistake! but it's still not updating :/

It is odd you said the sql alone worked, even with the row_id column name? This works:

CREATE OR REPLACE FUNCTION public.test_fn(row_id bigint) RETURNS void AS $$
    UPDATE messages SET message = 'test'
    WHERE id = 15;
$$ language sql volatile;

And it works just passing in the variable with id = row_id

name is text

No that is good

I basically am using this as a test to get my table to update, because what I actually want to do is use SQL to update my geometry column

So you do

select test_fn(1111)

and it does nothing? From sql editor?

would you be alright with video calling to figure this out quick?

About to eat dinner my time, so no. Post your table structure. RLS does not matter from the sql editor.

ok no prob, here it is

So you see something like this when your run the function? Also did you ever have a function by the same name with perhaps no variable or a different one?

This is what I see when I run it

That is you setting up the function, not running it

Where can I run it?

like in my image at top

ok let me try it

Should also then work from rpc with no rls on.

things are working now! thanks so much!