PostgreSQL throwing error on RAISE NOTICE with || operator

Question

Getting the following error with the following line of code:

RAISE NOTICE '*** Rolling back job run id ' || CONVERT(varchar, v_job_run_id)
             || ' for table ' || v_table_name || '***';

Error:

ERROR: syntax error at or near "|" LINE 43: RAISE NOTICE '*
Rolling back job run id ' || CONVERT(var...

Answer 1

A message string in RAISE XXXX statement should be literal constant - expression is not allowed there. It is similar to format string in printf like functions.

RAISE NOTICE 'my table has name %', tablename;

Second issue should be "CONVERT", that is not supported in Pg - use CAST instead or nothing, any parameter of RAISE statement is converted to text automatically.