Zabach, Elke wrote:
Derek Hinchliffe wrote:
Hi all,
I think this question has been asked a few times before, but I can't find any definite answer in the archives.
Are there any bitwise operators in MaxDB?
There are no bitwise operators available
Elke
SAP Labs Berlin
Thanks for the reply Elke.
In that case, does anyone have any suggestions for how to tackle my problem below? We were doing this in MySQL using bitwise operators and it was working well, but we wanted to migrate to MaxDB for other reasons.
We have a table column containing 8 bit values, each bit representing a different flag. We want to be able to easily SELECT based on combinations of these flags. Elementary stuff when you have bitwise operators, but without them I am at a bit of a loss.
Will we have to move this to the application layer? (a move which I am hesitant to do because we are dealing with large sets of data that generally filter down to small sets once we've isolated the flags we want)
Incidently - how are problems like this being tackled in the development of the MySQL-MaxDB proxy? Will bitwise operators be unavailable, implemented in the proxy somehow or translated somehow into statements that MaxDB can handle? Just curious...
Cheers Derek Hinchliffe
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
