Re: execute/perform and FOUND

From: "Marcin Mank" <marcin(dot)mank(at)gmail(dot)com>
To: "Karsten Hilbert" <Karsten(dot)Hilbert(at)gmx(dot)net>, "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: execute/perform and FOUND
Date: 2006-09-21 12:50:08
Message-ID: 04bb01c6dd7c$786cfe90$0c67a8c0@maniek
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> gives the result below. It seems inconsistent to me with
> regard to the FOUND variable. I would expect FOUND to always
> be false regardless of whether I use EXECUTE or PERFORM. I
> certainly do not expect it to be true for the third EXECUTE
> even assuming that PERFORM may have a bug. What is it that I
> am missing out on here ?
>

With:

perform cmd;
raise notice ''found (perform): %'', found;

You effectively do:
select 'select 1 from test where fk_item=1324314' ;

Try:

perform 1 from test where fk_item=1324314

Greetings
Marcin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2006-09-21 12:59:56 Re: execute/perform and FOUND
Previous Message Karsten Hilbert 2006-09-21 12:25:17 Re: execute/perform and FOUND