SQL Editor UPDATE command not working...

Hello Supabase community - I hope this is a simple question, as everywhere I've asked for advice I believe I've got my syntax right, but try as I can, I can't get a pretty simple SQL UPDATE query to work.

I'm trying to copy a value from within one of my jsonb columns to a dedicated column, for performance reasons... but I enter the following into the web Supabase SQL Editor:

update
  public.table_name
set
  name = jdata->>'nameId'
where
  name is null;

update
  public.table_name
set
  name = jdata->>'nameId'
where
  name is null;

And when I run it I just get the result of 'Success. No rows returned' and the table doesn't show any changes...

Any thoughts?

Supabase•3y ago•

3 replies

squidgemonster

SQL Editor UPDATE command not working...

update
  public.table_name
set
  name = jdata->>'nameId'
where
  name is null;

update
  public.table_name
set
  name = jdata->>'nameId'
where
  name is null;

And when I run it I just get the result of 'Success. No rows returned' and the table doesn't show any changes...

Any thoughts?

SQL Editor UPDATE command not working...

Similar Threads

SQL Editor UPDATE command not working...

Similar Threads

Similar Threads

Similar Threads