Blocks pl pg sql

Question

Blocks pl pg sql

Navigation

#1 by (0 votes)

0

I am starting to use plpgsql and postgresql and the truth is that I am a bit lost, I have an exercise in which I am asked to make a block that increases the salary of the employees by 10% of the average salary of the same, and I have done this:

CREATE OR REPLACE FUNCTION increment(salari INT) RETURNS int AS $$
DECLARE
    increment int NOT NULL := salari + ((avg(salari) * 10)/100);
BEGIN
    return salari + increment;
END;
$$ LANGUAGE plpgsql;

The case is that when applying the function does not return a correct result (I know that instead of the return I have to do a update and such, but I have put it like this to go testing) , I imagine that it will be because instead of an int, I have to work with some kind of data similar to double, but it does not recognize me.

Does anyone have any idea what I could do?

postgresql

asked by THR4SH3RP0L0 15.03.2017 в 16:47

source

1 answer

Record data once a month (Php mysql) how can the background be changed to a div? if I'm using materialize

score 0 · Answer 1

I just published this and I just realized that in the variable incremento was adding the salary; therefore, he was adding twice the salary.

The code would look like this:

CREATE OR REPLACE FUNCTION increment(salari INT) RETURNS int AS $$
DECLARE
    increment int NOT NULL := ((avg(salari) * 10)/100);
BEGIN
    return salari + increment;
END;
$$ LANGUAGE plpgsql;