How to assign variables in postgres sql [duplicate]

Question

DECLARE 
eno integer := 0;
emp string ;

select into eno emp_no from "public"."salaries" GROUP BY emp_no ORDER BY max(salary) DESC LIMIT 1;
-- gives the emp_no of the employee with maximim salary

select INTO emp CONCAT(first_name, ' ' , last_name) as "Name" from "employees" 
WHERE emp_no = eno;
-- gives the name of the employee with the emp_no from preveous result 

raise NOTICE "The Employe with maximum salary is %",emp;

Error message : ERROR: syntax error at or near "integer"

i tried to get the emp name with maximum salary please help

Related: stackoverflow.com/questions/69702049/…

user2138149
– user2138149

2023-04-02 07:39:58 +00:00
Commented Apr 2, 2023 at 7:39 — user2138149
– user2138149, Commented Apr 2, 2023 at 7:39

user2138149 · Accepted Answer · 2023-04-02 07:38:03Z

0

You need to separate your declarations from your initialization of values.

Do this:

DECLARE 
   eno integer;
BEGIN
   eno := 0;
... rest of your code here
END;

answered Apr 2, 2023 at 7:38

user2138149

18.7k32 gold badges161 silver badges324 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to assign variables in postgres sql [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related