improve FOUND in PL/PgSQL

From: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
To: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: improve FOUND in PL/PgSQL
Date: 2002-08-13 17:30:35
Message-ID: 87d6smzmx0.fsf@klamath.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

This patch improves the behavior of FOUND in PL/PgSQL. In Oracle,
FOUND is set whenever a SELECT INTO returns > 0 rows, *or* when an
INSERT, UPDATE, or DELETE affects > 0 rows. We implemented the first
part of this behavior, but not the second.

I also improved the documentation on the various situations in which
FOUND can be set (excluding inside FOR loops, which I still need to
think about), and added some regression tests for this behavior.

Cheers,

Neil

--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC

Attachment Content-Type Size
plpgsql_found-2.patch text/x-patch 5.8 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Ulrich Neumann 2002-08-13 17:42:48 Re: Antw: Re: Patch for NetWare support
Previous Message Tom Lane 2002-08-13 17:28:18 Re: Antw: Re: Patch for NetWare support