Here is a step-by-step guide to creating a PL/pgSQL procedure for incrementing employee salaries based on the conditions you provided:

Step 1: Define the procedure.

```sql
CREATE OR REPLACE PROCEDURE update_salary(emp_id INT)
LANGUAGE plpgsql
AS $$
```

Step 2: Declare the variables you will use.

```sql
DECLARE
emp_name VARCHAR;
emp_salary INT;
```

Step 3: Begin the procedure body.

```sql
BEGIN
```

Step 4: Retrieve the name and salary of the employee with the given ID.

```sql
SELECT name, salary INTO emp_name, emp_salary
FROM Employees
WHERE id = emp_id;
```

Step 5: Check if the employee's salary is less than 35000. If it is, increase it by 15%. Otherwise, increase it by 10%.

```sql
IF emp_salary

Question

Here is a step-by-step guide to creating a PL/pgSQL procedure for incrementing employee salaries based on the conditions you provided:

Step 1: Define the procedure.

```sql
CREATE OR REPLACE PROCEDURE update_salary(emp_id INT)
LANGUAGE plpgsql
AS $$
```

Step 2: Declare the variables you will use.

```sql
DECLARE 
    emp_name VARCHAR;
    emp_salary INT;
```

Step 3: Begin the procedure body.

```sql
BEGIN
```

Step 4: Retrieve the name and salary of the employee with the given ID.

```sql
    SELECT name, salary INTO emp_name, emp_salary
    FROM Employees
    WHERE id = emp_id;
```

Step 5: Check if the employee's salary is less than 35000. If it is, increase it by 15%. Otherwise, increase it by 10%.

```sql
    IF emp_salary < 35000 THEN
        emp_salary := emp_salary * 1.15;
    ELSE
        emp_salary := emp_salary * 1.10;
    END IF;
```

Step 6: Update the employee's salary in the database.

```sql
    UPDATE Employees
    SET salary = emp_salary
    WHERE id = emp_id;
```

Step 7: Print the employee's name and their updated salary.

```sql
    RAISE NOTICE 'Employee % has a new salary of %', emp_name, emp_salary;
```

Step 8: End the procedure body and the procedure definition.

```sql
END; 
$$;
```

Step 9: Call the procedure with an employee ID.

```sql
CALL update_salary(1);
```

This will print a message with the employee's name and their new salary.

Knowee AI · Accepted Answer