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>
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