/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

1 vote108 views1 answer
Round function in sql oracle
SQL
6 votes113 views2 answers
Mysql concatenate two columns into one
SQL
0 vote130 views1 answer
Convert multiple columns to ROws in sql server
SQL
5 votes126 views2 answers
Mysql where in array
SQL
3 votes108 views1 answer
Pl sql check if variable is empty
SQL
1 vote119 views1 answer
Show all event schedular on mysql
SQL
0 vote135 views1 answer
Mysql trigger to delete old data
SQL
0 vote128 views1 answer
Oracle pl/sql check if file exists
SQL
1 vote153 views1 answer
Insert many to many sql
SQL
7 votes112 views1 answer
Sql server convert string to date
SQL