X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 226D0534CF; Mon, 18 Apr 2005 13:08:11 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 68780-04; Mon, 18 Apr 2005 16:08:02 +0000 (GMT) Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244]) by svr1.postgresql.org (Postfix) with ESMTP id A5165534BF; Mon, 18 Apr 2005 13:08:00 -0300 (ADT) Received: from dinesh by secf.com (MDaemon.PRO.v7.2.2.R) with ESMTP id md50000657488.msg; Mon, 18 Apr 2005 09:08:04 -0700 Reply-To: From: "Dinesh Pandey" To: , Subject: 'Select INTO" in Execute (dynamic query ) Date: Mon, 18 Apr 2005 21:34:48 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_008C_01C5445E.745B4400" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcVEMFg3GEx/uXK7Rcua1fxF+IhXbw== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Mon, 18 Apr 2005 09:08:04 -0700 (not processed: message from valid local sender) X-MDRemoteIP: 220.227.32.11 X-Return-Path: dpandey@secf.com X-MDAV-Processed: mail.secf.com, Mon, 18 Apr 2005 09:08:09 -0700 Message-Id: <20050418160800.A5165534BF@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.571 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_90_100, HTML_MESSAGE, MSGID_FROM_MTA_ID, UPPERCASE_25_50 X-Spam-Level: * X-Archive-Number: 200504/710 X-Sequence-Number: 76623 This is a multi-part message in MIME format. ------=_NextPart_000_008C_01C5445E.745B4400 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_008C_01C5445E.745B4400 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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

        &nbs= p; vara    VARCHAR(10) :=3D'';

        &nbs= p; varb    VARCHAR(10) :=3D'';

          = result  VARCHAR(10) :=3D'Result';

          =

BEGIN  =          =

          = EXECUTE(

  =             &= nbsp;    'Select INTO vara, varb A1, A2 = from '|| $1

          = );

          =

RETURN result||': '|| vara ||' '|| varb;

 

END;

$$ LANGUAGE plpgsql;

 

 

Regards
Dinesh Pandey


 

------=_NextPart_000_008C_01C5445E.745B4400--