I have this function:
DECLARE _first_name text; _last_name text; BEGIN SELECT emp.first_name INTO _first_name, emp.last_name INTO _last_name, FROM employee emp LIMIT 1 END;
(I simplified the function to eliminate the information noise)
As you can see, i can get only 1 result because of 'LIMIT'. So i need to store this 2 columns into my 2 variables. But i am getting an error like 'INTO specified more than once'. How to bypass this, any ideas?
Use INTO once as follows:
INTO
SELECT emp.first_name, emp.last_name INTO _first_name, _last_name FROM employee emp LIMIT 1
Columns and variables must be in the same sequence respectively.
1.4m articles
1.4m replys
5 comments
56.9k users