db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dyre.Tjeldv...@Sun.COM
Subject Re: Does derby support bitwise operators in SQL?
Date Fri, 02 Mar 2007 16:14:42 GMT
Imran Hussain <imranh@imranweb.com> writes:

> Dan,
>
> Thanks for the response. I wonder if there is any plan to add support
> for this in the future?
>
> Imran.
>
>
>
>
> Dan Karp wrote:
>>> I'd like to know if Derby supports bitwise operators in SQL
>>> statements.     
>>
>> Nope.  Wish it did, but nope.
>>
>>   
>>> select *
>>> from MyTable
>>> where (status & 5) = 5

>From my reading of the SQL 2003 standard '(status & 5)' isn't a valid 'numeric
value expression'. But I'm not well versed in standardese so I could
be wrong.

-- 
dt


Mime
View raw message