Re: PLPGSQL and FOUND stange behaviour after EXECUTE - Mailing list pgsql-bugs

Константин <beholder@mmska.ru> writes:
> sql := 'insert into tbl' || suffix::text || ' values (1,1)';
> EXECUTE sql;
> IF NOT FOUND THEN
>  RAISE NOTICE 'NOT INSERTED';
> END IF;

EXECUTE does not set the FOUND flag.  See
http://developer.postgresql.org/docs/postgres/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
        regards, tom lane