A E <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])