/SQL/Raise notice in postgresql function

Raise notice in postgresql function

Postgres raise notice

RAISE INFO 'Hello World !';
RAISE NOTICE '%', variable_name;
RAISE NOTICE 'Current value of parameter (%)', my_var;
RAISE EXCEPTION '% cannot have null salary', EmpName;

Source: dbrnd.com

Raise notice in postgresql function

RAISE INFO 'Hello World !';
RAISE NOTICE '%', variable_name;
RAISE NOTICE 'Current value of parameter (%)', my_var;
RAISE EXCEPTION '% cannot have null salary', EmpName;

Similar codes

9 votes191 views2 answers
Mysql change value
SQL
0 vote260 views1 answer
Drop view sql
SQL
0 vote265 views1 answer
Pl sql round
SQL
2 votes161 views1 answer
Latest record in sql
SQL
0 vote282 views1 answer
Best sql collation
SQL
-1 vote235 views1 answer
Create view in mysql workbench
SQL
0 vote216 views2 answers
Sql stored procedure for access frontend
SQL
1 vote203 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote194 views1 answer
Select all tables linked server sql
SQL
0 vote211 views1 answer
Sql server for loop
SQL