=?koi8-r?B?68/O09TBztTJzg==?= <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
