/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 vote132 views1 answer
Select not matching data from two tables
SQL
0 vote125 views1 answer
Acual month sql
SQL
2 votes116 views1 answer
Oracle sql drop column if exists
SQL
0 vote161 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote141 views1 answer
Limit in access query
SQL
1 vote143 views1 answer
Write a query to create an empty table from an existing table?
SQL
37 votes313 views3 answers
Sql check duplicate value in column
SQL
3 votes121 views1 answer
Oracle APEX elapsed time
SQL
5 votes128 views1 answer
How to check nls timestamp format in oracle
SQL
4 votes119 views1 answer
Oracle table statistics last analyzed
SQL