DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:From:To:References:In-Reply-To:Subject:Date:Message-ID:MIME-Version:Content-Type:Content-Transfer-Encoding:X-Mailer:Thread-Index:Content-Language;
	b=19Ilb/AG7h9T+NBo7Vt+xVgAUyAhkTK1pXjj2RMHHzNcWVcHc1Eu+6UIMMkgdep//qRiAQmxbSa7MsQurQJLNCClW1cR+3/bkXpjUURWQqTuKWGW2ALljJWe9Wm78dCOshizTRfOTbySonfgsXRRQhiYn2Jp/o71rkUUAkbU5Gs=
	;
From: "David Johnston" <polobo@yahoo.com>
To: "'James Sharrett'" <jsharrett@tidemark.net>, <pgsql-sql@postgresql.org>
References: <CC713DA8.32CC%jsharrett@tidemark.net>
In-Reply-To: <CC713DA8.32CC%jsharrett@tidemark.net>
Subject: Re: returning values to variables from dynamic SQL
Date: Sat, 8 Sep 2012 19:42:42 -0400
Message-ID: <00ea01cd8e1b$a4435630$ecca0290$@yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thread-Index: AQG59Fc8OPqmBHkEEHYhDCjbEyxblZeoTegQ
Content-Language: en-us

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
From: pgsql-sql-owner@postgresql.org =
[mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of James Sharrett
Sent: Saturday, September 08, 2012 6:24 PM
To: pgsql-sql@postgresql.org
Subject: [SQL] returning values to variables from dynamic SQL

I have a PG function ( using plpgsql) that calls a number of sub =
functions
also in plpgsql. =A0I have two main problems that seem to be variations =
on the
same theme of running dynamic SQL from a variable with the EXECUTE =
statement
and returning the results back to a variable defined in the calling
function.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Please read:

http://www.postgresql.org/docs/9.0/interactive/plpgsql-statements.html#PL=
PGS
QL-STATEMENTS-EXECUTING-DYN

Basically when you use "EXECUTE" you do not embed the "INTO" as part of =
the
SQL query but rather INTO becomes a modifier of the EXECUTE itself:

EXECUTE 'some query'  INTO {variables}

David J.