Postgres Pro
Downloads
Home   >   mailing lists

PERFORM statement inside procedure - Mailing list pgsql-general

From Rajat Katyal
Subject PERFORM statement inside procedure
Date
Msg-id 000801c41bb3$75437e70$2105a8c0@bgdev001
Whole thread Raw
Responses Re: PERFORM statement inside procedure
List pgsql-general
Tree view
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 query is returning 0 records.
 
Please suggest me the solution.
 
Thanks and Regards,
Rajat. 

pgsql-general by date:

Previous
From: "Trilobite Trilobite"
Date:
Subject: SQL trees and other nonsense...
Next
From: "John Liu"
Date:
Subject: Re: select distinct w/order by