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
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 returning true even my qu
