A E <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org