/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 votes142 views1 answer
Null sql
SQL
0 vote125 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
9 votes134 views2 answers
Sql server check table exists
SQL
0 vote138 views1 answer
Default order by in mysql
SQL
0 vote143 views1 answer
Sql decode
SQL
0 vote138 views1 answer
Mysql count by month
SQL
0 vote131 views3 answers
Postgresql grant alter table to user
SQL
0 vote146 views1 answer
Mysql error 1251
SQL
0 vote175 views1 answer
Select count postgres double row count > 1
SQL
5 votes132 views2 answers
Mysqldump password
SQL