Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] 'Select INTO" in Execute (dynamic query ) - Mailing list pgsql-sql

From Tom Lane
Subject Re: [GENERAL] 'Select INTO" in Execute (dynamic query )
Date
Msg-id 23848.1113845209@sss.pgh.pa.us
Whole thread Raw
In response to 'Select INTO" in Execute (dynamic query )  ("Dinesh Pandey" <dpandey@secf.com>)
List pgsql-sql
Tree view 
"Dinesh Pandey" <dpandey@secf.com> writes:
> What's wrong with this code (ERROR:  syntax error at or near "INTO" at
> character 8)?

You can't use plpgsql's SELECT INTO in an EXECUTE'd command, because
SELECT INTO means something entirely different to the main SQL engine.

The usual workaround is to use FOR ... IN EXECUTE.  See the plpgsql docs.

            regards, tom lane

pgsql-sql by date:

Previous
From: "Dinesh Pandey"
Date:
Subject: 'Select INTO" in Execute (dynamic query )
Next
From: "A. Kulikov"
Date:
Subject: User Defined Functions Errors