On Wednesday 07 April 2004 08:30, Rajat Katyal wrote:
> Actually my problem is PERFORM is not updating the FOUND variable to false
> even when my query return no rows. Can you please tell me the better way to
> use PERFORM so that by running my select query I just come to know whether
> it returns
-
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Rajat Katyal" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, April 07, 2004 11:15 AM
Subject: Re: [GENERAL] PERFORM statement inside procedure
> "Rajat Katyal" <[EMAIL
"Rajat Katyal" <[EMAIL PROTECTED]> writes:
> checkPKSql := ''select * from "transform_customer_billing" '';
> checkPKSql := checkPKSql || '' where "inv_no" = '' || quote_literal(new=
> ."inv_no");
> PERFORM checkPKSql;
You seem to be confusing PERFORM with EXECUTE. They are very different.
The a
Rajat Katyal wrote:
Hi:
In postgres documentation its written that if we execute query as
PERFORM /query /inside our stored procedure/;/ *then the special
variable FOUND is set to true if the query produced at least one row, or
false if it produced no rows.*
**
But FOUND variable is always re
