I looked at the documentation before I ever posted anything. I didn't know how EXECUTE works and I actually thought the UPDATE statement itself would set the variable. Thanks for the reply. On Friday 02 September 2005 10:47 am, Tom Lane saith: > Terry Lee Tucker <terry@xxxxxxxx> writes: > > Will the FOUND variable be set, when using EXECUTE, as it would be with a > > normal UPDATE statement? > > The documentation is pretty specific about which plpgsql statements set > FOUND, and I don't see EXECUTE in that list ... > http://developer.postgresql.org/docs/postgres/plpgsql-statements.html#PLPGS >QL-STATEMENTS-DIAGNOSTICS > > regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
