Re: EXIST, NOT EXIST problem

From: --CELKO-- <joe.celko_at_trilogy.com>
Date: 20 Jun 2001 11:36:45 -0700
Message-ID: <7e67a7b3.0106201036.5c89c7e1_at_posting.google.com>


Perhaps I do not understand the problem. The EXISTS() predicate is either TRUE or FALSE, so you should be able to write

   IF EXISTS (...) THEN foo ELSE Bar ENDIF;

and not worry about repeating the test again. Received on Wed Jun 20 2001 - 20:36:45 CEST

Original text of this message