Re: sql question

>From: cklo@tst.hk.super.net (Mr Cheuk Kong Lo) >Date: 18 Aug 1997 11:23:46 GMT >X-Informix-List-Id: <news.41748> > >Very simple question (and yet I need to verify): > >Does Informix-SQL (in 6.0x r4gl) perform short-circuit evaluation >in the WHERE clause for AND/OR? Our engine is 7.22UC2 [...] >-- Linux + FreeBSD + HPUX + Solaris + AIX Thanks for including the version (and platform) information. The short answer to your question is 'No'. The AND and OR operators in both SQL and I4GL are not short-circuited. It isn't clear to me which product you are seeking the answer for, as I can identify references to 3 different products in your question -- ISQL, I4GL-RDS and either OnLine or SE. As it happens, the answer is the same in all of them, but this isn't always the case. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> PS: Warning I do not reply to messages with anti-spam in the return path.