Postgres Pro
Downloads
Home   >   mailing lists

Re: Pl/pgsql function fails when false - Mailing list pgsql-general

From Tom Lane
Subject Re: Pl/pgsql function fails when false
Date
Msg-id 22869.993160596@sss.pgh.pa.us
Whole thread Raw
In response to Pl/pgsql function fails when false  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
List pgsql-general
Tree view 
"Thalis A. Kalfigopoulos" <thalis@cs.pitt.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

pgsql-general by date:

Previous
From: "Thalis A. Kalfigopoulos"
Date:
Subject: Pl/pgsql function fails when false
Next
From: Ana Carolina Alonso de Armiño
Date:
Subject: postgres 7.0.3 with SuSE 7.1