PERFORM / FOUND, what's up? - Mailing list pgsql-sql

From Martin Brommer
Subject PERFORM / FOUND, what's up?
Date
Msg-id 3eae35d4$0$49113$e4fe514c@news.xs4all.nl
Whole thread Raw
Responses Re: PERFORM / FOUND, what's up?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Hi,

I'm trying to get an answer from a dynamic query using perform. The 
problem is that it sets the FOUND variable to true even when performing 
bogus queries.

Am I missing something here? The documentation says that PERFORM only 
sets FOUND to true if it finds and discards a row but doing something like:

qry := 'SELECT notafield FROM notatable'
PERFORM qry

Also sets FOUND to true, even more using a query like 'BLABLABLA'  also 
set found to true.

What am I doing wrong here?

Thanks for any help in advance,

Martin



pgsql-sql by date:

Previous
From: "Victor Yegorov"
Date:
Subject: Re: replace function
Next
From: Rajesh Kumar Mallah
Date:
Subject: Re: replace function