Postgres Pro
Downloads
Home   >   mailing lists

Re: Anything akin to an Evaluate Statement in Postgresql? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Anything akin to an Evaluate Statement in Postgresql?
Date
Msg-id 22262.1073283030@sss.pgh.pa.us
Whole thread Raw
In response to Re: Anything akin to an Evaluate Statement in Postgresql?  (A E <cooljoint@yahoo.com>)
Responses Re: Anything akin to an Evaluate Statement in Postgresql?  (A E <cooljoint@yahoo.com>)
List pgsql-hackers
Tree view 
A E <cooljoint@yahoo.com> writes:
> I tried to execute a dynamic sql string using the dynamic record
> column name but I getting this error: ERROR: syntax error at or near
> "into" at character 8. Does the execute statement not allow the into
> keyword

It does not :-(.  The best way of getting data back from an EXECUTE'd
select is to use a FOR ... IN EXECUTE loop.  See the docs.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: [ADMIN] IEEE 754
Next
From: Christopher Kings-Lynne
Date:
Subject: Composite GiST indexes?