POSTGRES, column "row_count" does not exist when using ROW_COUNT

Question

After running my function I am trying to display the amount of updated rows to the panel like so:

  RAISE NOTICE 'updated rows= %', ROW_COUNT;
  commit;
  RAISE NOTICE 'updated rows= %', ROW_COUNT;
  commit;
  END;

however I get an error of:

ERROR:  column "row_count" does not exist
LINE 1: SELECT ROW_COUNT

i'm pretty sure this is acceptable syntax, not sure why this is happening.

Answer 1

There is not any automatics variable named ROW_COUNT. You should to use statement GET DIAGNOSTICS yourvar = ROW_COUNT.