/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 vote259 views1 answer
Sql select max value for each group
SQL
0 vote251 views1 answer
Sql value exists in column
SQL
0 vote254 views1 answer
Oracle sql procedure return value
SQL
4 votes260 views2 answers
Convert utc to est sql
SQL
0 vote275 views1 answer
Mysql delete entire row on condition
SQL
0 vote268 views1 answer
Psql get table data types
SQL
3 votes237 views4 answers
Show columns from table
SQL
1 vote253 views1 answer
Install postgresql on raspberry pi
SQL
10 votes271 views2 answers
SQL rounding numbers
SQL
0 vote244 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL