=?koi8-r?B?68/O09TBztTJzg==?= <beholder(at)mmska(dot)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