SELECT last_name, job_id, salary,ĮLSE salary END "REVISED_SALARY" FROM employees For all other job roles, there is no increase in salary. We can use CASE to evaluate multiple conditions for a single variable, “job_id.” If “job_id” is “ACCOUNT,” the salary increase is 10% if “job_id” is “IT_PROG,” the salary increase is 15% if “job_id” is “SALES,” the salary increase is 20%. It facilitates conditional inquiries by doing the work of an IF-THEN-ELSE statement and applying it to many possible conditions. The CASE statement uses IF-THEN-ELSE logic within a single statement. Next, there is one condition: when x is greater than y it raises notice that “x is greater than y.” When that condition is not met, it raises the notice “x is not greater than y.” In this case, the condition is not met, so the ELSE clause is executed and the output for the ELSE part is printed. If the condition is false then it goes to the next statement after END IF.Īs in the first example, here 2 variables are declared at the start: x=10 and y=20. The IF condition runs when a condition is evaluated as true.
There are three main types of control structures available with PostgreSQL to use with stored procedures: IF, CASE, and LOOP. Stored procedures in PostgreSQL are ones that define a function for creating triggers or custom functions.
SUMMARY: This article reviews control structures that can be used in PostgreSQL stored procedures, with syntax and examples provided for each.
0 kommentar(er)
