I've seen BIT operators used in situations dealing with IP addresses (i.e. network/security management applications). For example, to determine if an IP address is part of a given network range (network number and netmask), I bitwise AND the IP address with the netmask, then compare the result to the network number.
Queries which group rows of IP addresses by network range would use the BIT operators, as would queries which search rows of network ranges for those that cover specific IP addresses. I'd guess that work-arounds can be found for most situations (i.e. pre-calculate the starting and ending IP address for a range and use BETWEEN()), but there may be some that require BIT operators. Pete. On Fri, Aug 1, 2008 at 2:40 PM, Brian Aker <[EMAIL PROTECTED]> wrote: > Hi! > > Any feelings from the audience on the BIT operators? > > A couple of notes: > 1) I am not talking about BOOL > 2) SET/ENUM give you BIT operations at an abstracted level (aka not BIT > math which few folks know now a days). > 3) Not matter what in Drizzle a BIT costs 1byte, so there is no real > storage save that people magically assume. > 4) We are not an analytics solution (we will be keeping ROLLUP though!). > > Personally I do not believe these belong in the database, and I do not > consider them user friendly. > > Cheers, > -Brian > > -- > _______________________________________________________ > Brian "Krow" Aker, brian at tangent.org > Seattle, Washington > http://krow.net/ <-- Me > http://tangent.org/ <-- Software > _______________________________________________________ > You can't grep a dead tree. > > > > > _______________________________________________ > Mailing list: > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > Post to : [email protected] > Unsubscribe : > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
