PostgreSQL throwing error on RAISE NOTICE with || operator

Viewed 9169

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...

1 Answers
Related