/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 vote108 views2 answers
Mysql regexp match word
SQL
2 votes119 views1 answer
Postgresql format date dd/mm/yyyy
SQL
4 votes155 views1 answer
Sql delete multiple conditions
SQL
2 votes121 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote129 views1 answer
Sql use with to get value counts and percentages
SQL
10 votes117 views1 answer
Oracle dba_dependencies
SQL
5 votes105 views1 answer
Postgresql functions
SQL
1 vote116 views1 answer
Oracle sql create view
SQL
0 vote128 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
1 vote118 views1 answer
Mysql show long running queries
SQL