Re: Pl/pgsql function fails when false

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Pl/pgsql function fails when false
Date: 2001-06-21 21:56:36
Message-ID: 22869.993160596@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Thalis A. Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu> writes:
> Any ideas why the one would fail while the other would work?

The first one is wrong.

Hint: the loop executes zero times if the SELECT doesn't find anything.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ana Carolina Alonso de Armiño 2001-06-21 22:12:22 postgres 7.0.3 with SuSE 7.1
Previous Message Thalis A. Kalfigopoulos 2001-06-21 21:24:06 Pl/pgsql function fails when false