/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

3 votes217 views3 answers
Update con select postgresql
SQL
0 vote209 views1 answer
Query string starts with vowels
SQL
0 vote256 views1 answer
Sql select first and last record of each group
SQL
13 votes192 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote272 views1 answer
Mysql loop through databases and execute query
SQL
1 vote249 views2 answers
List tables sqlalchemy
SQL
0 vote194 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote182 views1 answer
Close sql query vb.net
SQL
2 votes186 views2 answers
Function in sql
SQL
2 votes191 views6 answers
In in sql
SQL