Postgres Pro
Downloads
Home   >   mailing lists

Re: Sending function parametars within EXECUTE ''SELECT... - Mailing list pgsql-sql

From Stewart Ben (RBAU/EQS4) *
Subject Re: Sending function parametars within EXECUTE ''SELECT...
Date
Msg-id E253BDD7F008244585AEE87AF8F0224F116C7A7C@cl-mail01.au.bosch.com
Whole thread Raw
In response to Sending function parametars within EXECUTE ''SELECT...  (Mario Splivalo <mario.splivalo@mobart.hr>)
Responses Re: Sending function parametars within EXECUTE ''SELECT...
List pgsql-sql
Tree view 
> 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.stewart@au.bosch.com
http://www.bosch.com.au/

pgsql-sql by date:

Previous
From: Mario Splivalo
Date:
Subject: Re: Sending function parametars within EXECUTE ''SELECT...
Next
From: Mario Splivalo
Date:
Subject: Re: Sending function parametars within EXECUTE ''SELECT...