/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

2 votes564 views1 answer
Oracle virtual column
SQL
3 votes258 views3 answers
Mysql select table names
SQL
0 vote276 views1 answer
Vowels in sql
SQL
0 vote245 views1 answer
Postgres create database if not exists
SQL
2 votes264 views1 answer
Sql like variable
SQL
0 vote258 views1 answer
Sql server update top n records
SQL
3 votes291 views3 answers
Mysql auto increment after delete
SQL
7 votes260 views2 answers
Sql server drop temp table if exists
SQL
0 vote276 views1 answer
Mysql repair a table
SQL
0 vote313 views2 answers
Postgres isnull
SQL