Re: PERFORM / FOUND, what's up?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martin Brommer <martin(at)brommer(dot)nl>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: PERFORM / FOUND, what's up?
Date: 2003-05-01 01:53:33
Message-ID: 25886.1051754013@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Martin Brommer <martin(at)brommer(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Roberto Mello 2003-05-01 02:16:46 Re: Stored Procedure Question
Previous Message Christopher Kings-Lynne 2003-05-01 01:51:41 Re: [SQL] 7.3 analyze & vacuum analyze problem