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 16273.1073404619@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
A E <cooljoint@yahoo.com> writes:
> I tried to use a for in loop to execute the statement to try to get some dynamic functionality but I get "ERROR:
missing".." at end of SQL expression" what am I doing wrong?
 

Did you declare the loop variable (here,  "objectdefinition") as a
record or rowtype variable?  If the loop variable is not known,
plpgsql assumes this is a locally-declared-integer kind of FOR loop,
which leads it to expect the lowbound .. highbound kind of syntax,
which leads to the above error message.
        regards, tom lane


pgsql-hackers by date:

Previous
From: A E
Date:
Subject: Re: Anything akin to an Evaluate Statement in Postgresql?
Next
From: A E
Date:
Subject: Re: Anything akin to an Evaluate Statement in Postgresql?