. Re: [NEW][SQL] operator IN implemented (Ruslan Zasukhin)

[Lloyd Butler]

Ruslan,

Does this return the records in the order they are in the in (..) set, or as
they appear in the database?

By looking at your code below, it looks like it is as they appear in the
database. What is the standard way for them to be returned?

I Ingres they would be returned in the order that they were listed, what
about other implementations?

thanks


Lloyd Butler
Product and System Development Supervisor
TWN Commercial Services


> Message: 4
> Date: Sun, 01 Jun 2003 22:59:52 +0300
> From: Ruslan Zasukhin <sunshine at public.kherson.ua>
> Subject: [NEW][SQL]  operator IN implemented
> To: <valentina at lists.macserve.net>, David Studstill
> 	<david at artsystems.com>
> Message-ID: <BB0035E8.1D5FC%sunshine at public.kherson.ua>
> Content-Type: text/plain; charset="US-ASCII"
> 
> Hi Guys,
> 
> Implemented operator IN for SQL of 1.9.8
> 
> In the form:
> 
>     WHERE fld in ( v1, v2, v3, ... )
> 
> This operator work with any type and values for which you can write
> 
>     WHERE (fld = v1 OR fld = v2 OR fld = v3)
> 
> 
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need for speed ]
>