PERFORM / FOUND, what's up?

From: Martin Brommer <martin(at)brommer(dot)nl>
To: pgsql-sql(at)postgresql(dot)org
Subject: PERFORM / FOUND, what's up?
Date: 2003-04-29 08:21:01
Message-ID: 3eae35d4$0$49113$e4fe514c@news.xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rado Petrik 2003-04-29 09:14:25 ALERT column
Previous Message mallah 2003-04-29 00:14:43 Re: plpgsql Question..