Bitwise OR in a group statement

From: "Greg Gazanian" <ggazan(at)ausd(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Bitwise OR in a group statement
Date: 2006-06-21 18:24:55
Message-ID: s4992c91.072@smtpgtwy.ausd.k12.ca.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I was wondering if anyone happens to know whether there is an Aggregate function available in Postgres that can do an OR on a column of the bit varying type. For example I would like to do something as follows:

bitstring
*--------
1110
0100
1111

SELECT bitwise_or(bitstring) FROM table;

Resulting in:
1111

Any thoughts? Thanks.

- Greg Gazanian
Network Systems Analyst
Technology and Information Services
Arcadia Unified School District

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jasbinder Bali 2006-06-21 18:44:38 Re: Dynamic loading of C functions: Badly stuck
Previous Message Jasbinder Bali 2006-06-21 18:05:54 Re: Dynamic loading of C functions: Badly stuck