From: Mario Splivalo <mario.splivalo@mobart.hr>
To: pgsql-sql@postgresql.org
Subject: Re: Sending function parametars within EXECUTE ''SELECT...
Date: Thu, 29 Sep 2005 09:20:45 +0200
Message-ID: <1127978445.27771.5.camel@ekim> (raw)
In-Reply-To: <E253BDD7F008244585AEE87AF8F0224F116C7A7C@cl-mail01.au.bosch.com>
References: <E253BDD7F008244585AEE87AF8F0224F116C7A7C@cl-mail01.au.bosch.com>
On Thu, 2005-09-29 at 16:36 +1000, Stewart Ben (RBAU/EQS4) * wrote:
> > Is there a way to assing variable a value returned from query that
> > accesses the temporary table in a way you explained above?
> >
> > For instance, I can do:
> >
> > myValue := col2 FROM tmpTbl WHERE someValue = somethingElse...
>
> If I'm parsing this correctly, all you need do is:
>
> SELECT col2 INTO myValue FROM .......
>
So, when accessing temporary tables, like this:
EXECUTE ''SELECT col2 INTO myValue FROM tmpTable...''
Don't have postsgres handy now, I'll check that ASAP, but somehow I feel
that I'd run into same problems as before.
I'll try and I'll post a reply here.
Mario
--
Mario Splivalo
Mob-Art
mario.splivalo@mobart.hr
"I can do it quick, I can do it cheap, I can do it well. Pick any two."
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mario.splivalo@mobart.hr
Subject: Re: Sending function parametars within EXECUTE ''SELECT...
In-Reply-To: <1127978445.27771.5.camel@ekim>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox