Robert Citek wrote:
>Which makes sense for efficiency. But it sure would be nice to have
>an API which abstracts out the bit-shifting.
>
>For example:
>
> update t set pets = remove_from_set('cat', pets)
>
>is a lot easier to understand and not dependent on the order in which
>the set was defined than:
>
> update t set pets = pets & ~2
>
>
>
There are some bit logical ops:
http://dev.mysql.com/doc/refman/5.0/en/bit-functions.html
"Don't use advice:"
http://dev.mysql.com/tech-resources/articles/mysql-set-datatype.html
You could write your own user functions*. And you can extend MySQL with
C functions. I did this once. Not for the faint of heart.
Don't use em. Use columns, if you can.
*not sure if this is possibe pre-5.0.
Ed
--
Ed Howland
WDT Solutions, LLC.
[EMAIL PROTECTED]
(314) 962-0766
_______________________________________________
CWE-LUG mailing list
[email protected]
http://www.cwelug.org/
http://www.cwelug.org/archives/
http://www.cwelug.org/mailinglist/
