Re: Anything akin to an Evaluate Statement in Postgresql?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: A E <cooljoint(at)yahoo(dot)com>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Anything akin to an Evaluate Statement in Postgresql?
Date: 2004-01-05 06:10:30
Message-ID: 22262.1073283030@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

A E <cooljoint(at)yahoo(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Browne 2004-01-05 06:21:37 Re: Is my MySQL Gaining ?
Previous Message Ian Barwick 2004-01-05 06:08:52 Re: Is my MySQL Gaining ?