Re: bitwise or on column

Check out this link by Connor McDonald for bitor and bitxor.

http://www.jlcomp.demon.co.uk/faq/bitwise.html

• J. Yang

"Stephan Bressler" <stephan.bressler_at_siemens.com> wrote in message news:<ah0r4e$a82$1_at_news.mch.sbs.de>...
> Hi all,
>
> I'm looking for a function doing a bitwise or on a column (number)
> containing permissions, e.g. 1=read, 2=write, 4=exec, ... (so 5 = exec+read
> permission).
> There are several rows per user and all permissions should be aggregated.
> The function should be used like
>
> select bitor(permissions)
> from acl
> where username='scott tiger';
>
> TIA
> Stephan
Received on Mon Jul 22 2002 - 12:01:49 CDT