Mysql version 8.0, distrib 3.22.32
select (1 < 5 < 3) = 1
select ((1<5) < 3) = 1
select (1< (5 < 3)) = 0
In this version, apparently left to right.
Regards,
Rich
At 05:16 PM 6/14/01 +0100, Jon Haworth wrote:
> > And why do you think it should return 0 ?
> >
> > ( 1 < 5 ) returns 1.
> > ( 1 < 3 ) returns 1.
> > ( 1 < 5 < 3 ) should then return 1.
> >
> > Or am I missing something?
> >
>
>I think probably becuse ( 5 < 3 ) returns 0.
>
>Depends how you read it, either as "1 is less than 5 and less than 3" or "1
>is less than 5 and 5 is less than 3".
>
>Of course the real question is "how does MySQL read it?" :-)
>
>Cheers
>Jon
>
>
>**********************************************************************
>'The information included in this Email is of a confidential nature and is
>intended only for the addressee. If you are not the intended addressee,
>any disclosure, copying or distribution by you is prohibited and may be
>unlawful. Disclosure to any party other than the addressee, whether
>inadvertent or otherwise is not intended to waive privilege or
>confidentiality'
>
>**********************************************************************
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Regards,
Rich
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php