/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

60 votes338 views6 answers
Add column in sql
SQL
0 vote202 views1 answer
Redudancy in SQL
SQL
3 votes215 views1 answer
Sql print all names that start with a given letter
SQL
4 votes197 views1 answer
Sql any
SQL
0 vote193 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote212 views1 answer
Sql reverse order of results
SQL
1 vote198 views1 answer
Set statistics on in ssms
SQL
1 vote213 views1 answer
How to group by month using sql server
SQL
10 votes196 views3 answers
Sql limit results
SQL
1 vote201 views4 answers
Psql check tables command
SQL