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

From Tom Lane
Subject Re: PERFORM / FOUND, what's up?
Date
Msg-id 25886.1051754013@sss.pgh.pa.us
Whole thread Raw
In response to PERFORM / FOUND, what's up?  (Martin Brommer <martin@brommer.nl>)
List pgsql-sql
Martin Brommer <martin@brommer.nl> writes:
> qry := 'SELECT notafield FROM notatable'
> PERFORM qry
> Also sets FOUND to true, even more using a query like 'BLABLABLA'  also 
> set found to true.

I think you are looking for EXECUTE, not PERFORM.  The above only
confirms that indeed "qry" is a scalar variable --- its contents
are not examined.
        regards, tom lane



pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: EASY QUESTION!!
Next
From: Roberto Mello
Date:
Subject: Re: Stored Procedure Question