/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

1 vote259 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
0 vote219 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
2 votes304 views1 answer
How to create sql database
SQL
1 vote153 views3 answers
Grant syntax in sql
SQL
1 vote176 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
0 vote295 views1 answer
Mysql select field if condition
SQL
16 votes163 views2 answers
Add column to all tables after first column mysql
SQL
6 votes178 views5 answers
Sql add months to date
SQL
-1 vote126 views1 answer
Oracle db list usernames
SQL
5 votes221 views3 answers
Sql server utc to local
SQL