/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

0 vote178 views1 answer
Stored function in sql
SQL
0 vote177 views4 answers
How to get max salary in each department in sql
SQL
23 votes166 views6 answers
Delete all rows from table sql
SQL
5 votes161 views3 answers
Mysql update field from one table to another
SQL
6 votes169 views1 answer
Wordpress change user password sql
SQL
0 vote165 views2 answers
Show slave status mysql
SQL
0 vote158 views1 answer
How to save data in database in mysql node
SQL
7 votes160 views1 answer
Append column sql
SQL
10 votes165 views1 answer
Oracle dba_dependencies
SQL
20 votes196 views4 answers
Sql count if
SQL