/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

8 votes195 views1 answer
Insert a select statement into a table
SQL
10 votes154 views4 answers
SELECT FROM WHERE
SQL
0 vote154 views1 answer
Sqlite insert or update
SQL
0 vote185 views1 answer
Psql create usr
SQL
0 vote299 views1 answer
Hue hive UploadingTextFiletoHive
SQL
0 vote156 views2 answers
Oracle select
SQL
19 votes180 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
1 vote170 views1 answer
Postgres cast as currency format
SQL
1 vote171 views1 answer
Sample clause in sql
SQL
0 vote153 views1 answer
Influxdb clone measurement
SQL