I want to store the value of this query inside a Stored Procedure:
select * from myname;
using
select * into mydata from myname
but an error "mydata" is not a known variable occurs. Is there a way to store those results into a variable in postgre?
-
it's an sql inside a stored procedure.user3204806– user32048062014-08-01 06:36:09 +00:00Commented Aug 1, 2014 at 6:36
-
Then you need to show us the full code.user330315– user3303152014-08-01 06:46:41 +00:00Commented Aug 1, 2014 at 6:46
Add a comment
|
1 Answer
Assuming you are trying to do this in the context of a PL/PgSQL function, then you have to declare the variable first.
CREATE OR REPLACE FUNCTION foobar() RETURNS void AS $$
DECLARE
mydata RECORD;
BEGIN
SELECT * INTO mydata FROM mytable;
-- now do something with mydata
END
$$ LANGUAGE plpgsql;
See:
5 Comments
user3204806
thank you...but i cant use mydata for a query like this one :
select * from mydata, i've got the error relation "mydata" does not exist. Can ou help me in this matter?
harmic
You will need to explain better what you are trying to do. Are you trying to select from the variable? Or select from a table named by the variable?
user3204806
Im trying to select from the variable.
harmic
Afaik you cannot select from a variable. Maybe you had better open a new question describing what you are trying to achieve at a higher level
user3204806
thanks @harmic im a beginner when it comes to stored procedure.