| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | aklaver(at)comcast(dot)net |
| Cc: | pgsql-sql(at)postgresql(dot)org, Mulham freshcode <mulhamcode(at)yahoo(dot)com>, "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
| Subject: | Re: select into |
| Date: | 2006-11-24 16:02:00 |
| Message-ID: | 4198.1164384120@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Adrian Klaver <aklaver(at)comcast(dot)net> writes:
> On Thursday 23 November 2006 08:45 pm, Tom Lane wrote:
>> This should work --- in PG 8.1 or later.
> The documentation for pl/pgsql in 8.1 and higher says different.
> http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
> " SELECT INTO is not currently supported within EXECUTE."
That says you can't do
EXECUTE 'select ... into foo ...';
which is not the same thing as
EXECUTE 'select ...' into foo;
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mulham freshcode | 2006-11-25 04:17:43 | Re: select into |
| Previous Message | Adrian Klaver | 2006-11-24 15:30:33 | Re: select into |