IDS Forum

Re: RE: Alternative to NOT IN

Posted By: Jonathan Leffler
Date: Tuesday, 18 January 2011, at 4:41 p.m.

In Response To: Re: RE: Alternative to NOT IN (NAVEEN NAIK)

On Tue, Jan 18, 2011 at 11:18, NAVEEN NAIK <navnaik@gmail.com> wrote:

> Thanks for the help.
>
> I was trying for the LEFT OUTER JOIN, it gave me a syntax error, so i was
> under the assumption that this is not possible in Informix IDS.
>
> Now its running faster than a bullet :)
>

Good - glad to hear something worked (but which version of the SQL statement
are you using? The NOT EXISTS or the NOT IN?). Please remember that I
don't have the context for what you chose - neither does anyone else.

LEFT OUTER JOIN et al are a distressingly recent addition to IDS - one
advantage of staying current is that you get useful new features such as
this. AFAICR, it was added in IDS 10.00, and I've been very impressed with
the implementation. I've pushed it hard and don't think I've found a bug in
the code yet, despite some excruciating operations in nested queries, etc.
A few times I thought I'd found something, but on more careful
investigation, it turned out to be pilot error on my part - invalid SQL
syntax, or not the answer I expected but the correct answer nonetheless. It
has been rock solid in my experience.

--
Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."

--001636c5c24112b2ea049a25c44b

Messages In This Thread

• Alternative to NOT IN
  NAVEEN NAIK -- Tuesday, 18 January 2011, at 12:02 p.m.
  • RE: Alternative to NOT IN
    Everett Mills -- Tuesday, 18 January 2011, at 12:07 p.m.
    • Re: RE: Alternative to NOT IN
      NAVEEN NAIK -- Tuesday, 18 January 2011, at 2:18 p.m.
      • Re: RE: Alternative to NOT IN
        Jonathan Leffler -- Tuesday, 18 January 2011, at 4:41 p.m.
  • RE: Alternative to NOT IN
    Tony Peterman -- Tuesday, 18 January 2011, at 12:21 p.m.
  • Re: Alternative to NOT IN
    Jonathan Leffler -- Tuesday, 18 January 2011, at 12:26 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.