From: | John DeSoi <desoi(at)pgedit(dot)com> |
---|---|
To: | Mark J Camilleri <markjcamilleri(at)yahoo(dot)co(dot)uk> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Error on dynamic code. |
Date: | 2005-07-15 19:26:35 |
Message-ID: | 5C174834-4EDD-46C2-9C73-A02B3D148545@pgedit.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Jul 14, 2005, at 3:46 AM, Mark J Camilleri wrote:
>
>
> The funny thing is that the documentation I read about SELECT INTO
> and RECORD types give the following example, amongst others:
See the section below that on EXECUTE:
> The results from SELECT commands are discarded by EXECUTE, and
> SELECT INTO is not currently supported within EXECUTE. So there is
> no way to extract a result from a dynamically-created SELECT using
> the plain EXECUTE command. There are two other ways to do it,
> however: one is to use the FOR-IN-EXECUTE loop form described in
> Section 35.7.4, and the other is to use a cursor with OPEN-FOR-
> EXECUTE, as described in Section 35.8.2.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Schreiber | 2005-07-17 17:34:54 | Re: difference between all RDBMSs |
Previous Message | Devrim GUNDUZ | 2005-07-15 18:03:34 | Re: Postgres for Fedora Core 2 OS **************** |