Re: Is this stuff really SQL 92 compliant

In article <32v6m1$hum_at_cs3.brookes.ac.uk>, p0070621_at_brookes.ac.uk (wareing pti) writes:
> Bill Wood (wood_at_dess0.light.ge.com) wrote:
> > In article <CuEL92.E23_at_genasys.com.au>, michaelh_at_genasys.com.au
> >(Michael Haldey) writes:
> > |> According to the Oracle SQL manual,
> > |> between x and y
> > |> means
> > |> x <= value <= y
 

> > This unexpected definition of 'between' is the one defined by the SQL
> > standard. It doesn't match my understanding of the english word
> > between, but hey, this is SQL not English.
>
> So you define 'a number between 1 and 10' to be 2,3,4,5,6,7,8 or 9?
> And 'between Monday and Friday' to be Tuesday, Wednesday or Thursday?
>
> SQL's use of 'between' means 'between (inclusive)'. The English word
> 'between' can mean 'between (inclusive)' or 'between (exclusive)'
> depending on context.
>
> --
> Tommy Wareing
> Oxford Brookes University
> 0865-483389

But he has the = sign in there.

The discussion was whether or not we were between a rock and a hard place, or a hard place and a rock. Forcing a restriction like

   boundary1 <= value <= boundary2
is just a cop-out on the part of the coders or a mistake in the standard. As it stands now, every place I allow the users to input ranges for a between requires an extra validation routine with a swap() function.

Maybe we'll tell Oracle that we have between 400 and 350 users (so our new license fee is null), or offer to pay them between $100,000 and $75,000 next year for support ;-}

Terry Greenlaw (on-site) z50816_at_mip.lasc.lockheed.com Encompass Technologies greenlaw_at_crl.com

----------------------- Oracle error of the week ------------------------
FRM-47111: Cannot copy value to item <name>

    Cause: You tried to use the copy built-in on an image item.    Action: Find some other way to copy or reproduce the data. Received on Fri Aug 19 1994 - 18:21:11 CEST