Re: Sending function parametars within EXECUTE ''SELECT...

From: "Stewart Ben (RBAU/EQS4) *" <Ben(dot)Stewart(at)au(dot)bosch(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Sending function parametars within EXECUTE ''SELECT...
Date: 2005-09-29 06:36:43
Message-ID: E253BDD7F008244585AEE87AF8F0224F116C7A7C@cl-mail01.au.bosch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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 .......

Best regards,

Ben Stewart

--
Robert Bosch (Australia) Pty. Ltd.
Engineering Quality Services, Student Software Engineer (RBAU/EQS4)
Locked Bag 66 - Clayton South, VIC 3169 - AUSTRALIA
mailto:ben(dot)stewart(at)au(dot)bosch(dot)com
http://www.bosch.com.au/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mario Splivalo 2005-09-29 07:20:45 Re: Sending function parametars within EXECUTE ''SELECT...
Previous Message Mario Splivalo 2005-09-29 06:30:31 Re: Sending function parametars within EXECUTE ''SELECT...