Ray Madigan wrote:
I thought that the documentation said I couldn't use EXECUTE on a SELECT
INTO?
"37.6.5. Executing Dynamic Commands
Oftentimes you will want to generate dynamic commands inside your
PL/pgSQL functions, that is, commands that will involve different tables
or different data typ
On Wed, 10 Oct 2007, Ray Madigan wrote:
I thought that the documentation said I couldn't use EXECUTE on a SELECT
INTO?
Try "for record_var in select ..." Look for 36.7.4 Looping Through
Query Results in the docs.
Daniel
---(end of broadcast)-
I thought that the documentation said I couldn't use EXECUTE on a SELECT
INTO?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Scott Marlowe
Sent: Wednesday, October 10, 2007 11:10 AM
To: Ray Madigan
Cc: Pgsql-Sql
Subject: Re: [SQL] Computed table na
On 10/10/07, Ray Madigan <[EMAIL PROTECTED]> wrote:
> I have a problem that I don't know where to look to understand the problem.
>
> I have a function that I first select to get a table name followed by
> another select into on that table name. If someone could tell me where to
> look to solve th
I have a problem that I don't know where to look to understand the problem.
I have a function that I first select to get a table name followed by
another select into on that table name. If someone could tell me where to
look to solve this problem I would appreciate it.
It is something like
DECL
