Subject Re: [Firebird-Java] Help: odd and even
Author maurizio
hi,
thank's for help, i have resolved with MOD function, but your solutions
is very good....

>Hi.
>
>where ( field / 2 ) * 2 = field.
>
>(Don't do this for large tables. This is hell for the query optimizer. Use a
>precomputed column instead and have a combined index on that field and the
>primary key.)
>
>Regards,
> Steffen
>
>
>
>
>>-----Original Message-----
>>From: maurizio [mailto:maurizio@...]
>>Sent: Wednesday, March 16, 2005 2:54 PM
>>To: Firebird-Java@yahoogroups.com
>>Subject: [Firebird-Java] Help: odd and even
>>
>>
>>
>>Hi,
>>It's possible to select odd or even number in a INTEGER field
>>by query?
>>thak's
>>
>>--
>> Maurizio Poli
>>
>>Etarom Multimedia Project
>>Via del Tiglio 45
>>56012 Calcinaia (PI)
>>Tel & Fax 0587-59108
>>cell 340 8398772
>>E-mail maurizio@...
>>
>>****************************************
>>Qualora questo messaggio fosse da Voi ricevuto per errore
>>vogliate cortesemente darcene notizia a mezzo telefax o
>>e-mail e distruggere il messaggio ricevuto erroneamente.
>>Quanto precede ai fini del rispetto del D.Lgs 196/03 sulla
>>tutela dei dati personali.
>>****************************************
>>
>>
>>
>>
>>
>>
>>
>>
>>Yahoo! Groups Links
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>


--
Maurizio Poli

Etarom Multimedia Project
Via del Tiglio 45
56012 Calcinaia (PI)
Tel & Fax 0587-59108
cell 340 8398772
E-mail maurizio@...

****************************************
Qualora questo messaggio fosse da Voi ricevuto per errore vogliate cortesemente darcene notizia a mezzo telefax o e-mail e distruggere il messaggio ricevuto erroneamente.
Quanto precede ai fini del rispetto del D.Lgs 196/03 sulla tutela dei dati personali.
****************************************