Re: PLPGSQL and FOUND stange behaviour after EXECUTE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Константин <beholder(at)mmska(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: PLPGSQL and FOUND stange behaviour after EXECUTE
Date: 2004-09-30 16:26:02
Message-ID: 17803.1096561562@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2004-09-30 16:37:39 consultant
Previous Message Константин 2004-09-30 16:02:59 PLPGSQL and FOUND stange behaviour after EXECUTE