PERFORM statement inside procedure

From: "Rajat Katyal" <rajatk(at)intelesoftech(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: PERFORM statement inside procedure
Date: 2004-04-06 08:45:01
Message-ID: 000801c41bb3$75437e70$2105a8c0@bgdev001
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bernhard Ankenbrand 2004-04-06 11:22:26 Crash in postgres/linux on verly large database
Previous Message C G 2004-04-06 08:23:40 Re: Storing jpgs