'Select INTO" in Execute (dynamic query )

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

Responses

Browse pgsql-general by date

  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

Browse pgsql-sql by date

  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