Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group