From: | "Dinesh Pandey" <dpandey(at)secf(dot)com> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org> |
Subject: | 'Select INTO" in Execute (dynamic query ) |
Date: | 2005-04-18 16:04:48 |
Message-ID: | 20050418160800.A5165534BF@svr1.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
Hi
What's wrong with this code (ERROR: syntax error at or near "INTO" at
character 8)?
Problem: I want to put A1, A2 values in two variables vara, varb.
CREATE OR REPLACE FUNCTION test(text)
RETURNS VARCHAR AS $$
Declare
vara VARCHAR(10) :='';
varb VARCHAR(10) :='';
result VARCHAR(10) :='Result';
BEGIN
EXECUTE(
'Select INTO vara, varb A1, A2 from '|| $1
);
RETURN result||': '|| vara ||' '|| varb;
END;
$$ LANGUAGE plpgsql;
Regards
Dinesh Pandey
From | Date | Subject | |
---|---|---|---|
Next Message | Bjørn T Johansen | 2005-04-18 16:24:37 | Building a "complex" select? |
Previous Message | Jeff Eckermann | 2005-04-18 14:57:23 | Re: ADO and PostgreSQL functions |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-04-18 17:26:49 | Re: 'Select INTO" in Execute (dynamic query ) |
Previous Message | Philippe Lang | 2005-04-18 15:13:35 | Re: outer join in ms query |