Re: Where clause ordering
From: Doug Anderson <dganderso_at_figmnt.tayloru.edu>
Date: 1995/08/24
Message-ID: <1995Aug24.085202.2268_at_figmnt.tayloru.edu>#1/1
Date: 1995/08/24
Message-ID: <1995Aug24.085202.2268_at_figmnt.tayloru.edu>#1/1
> Intersetingly, changing the query to:
>
> select count(*) from lookups
> where
> to_number(value) = 0;
> and class in (123,456)
>
> was sufficient to change the predicate precedence and cause the
> query to fail again.
Sorry, I can't resist. Maybe the semi-colon BEFORE the 'and' might have something to do with it. ;-] Received on Thu Aug 24 1995 - 00:00:00 CEST