| From: | Janning Vygen <vygen(at)gmx(dot)de> |
|---|---|
| To: | "Alexander M(dot) Pravking" <fduch(at)antar(dot)bryansk(dot)ru>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Results from EXECUTE |
| Date: | 2002-08-16 16:49:33 |
| Message-ID: | 200208161649.g7GGnZd18612@janning.planwerk6.local |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Am Freitag, 16. August 2002 18:26 schrieb Alexander M. Pravking:
> How can I obtain results from an EXECUTE statement
> within a pl/PgSQL function?
From the docs: plpgsql-statements.html postgres 7.2.1
"The results from SELECT queries are discarded by EXECUTE, and SELECT
INTO is not currently supported within EXECUTE. So, the only way to
extract a result from a dynamically-created SELECT is to use the
FOR-IN-EXECUTE form described later."
Look at the example in the docs.
janning
--
Planwerk 6 /websolutions
Herzogstrasse 86
40215 Duesseldorf
fon 0211-6015919
fax 0211-6015917
http://www.planwerk6.de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajesh Kumar Mallah. | 2002-08-17 05:32:58 | Difference between is true and = 't' in boolean feild. & bitmap indexes |
| Previous Message | Alexander M. Pravking | 2002-08-16 16:26:13 | Results from EXECUTE |