Combining values in a column - Mailing list pgsql-sql

From Stephen Quinney
Subject Combining values in a column
Date
Msg-id 20050415092227.GA24135@computing-services.oxford.ac.uk
Whole thread Raw
Responses Re: Combining values in a column  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-sql
I have a query which returns a single column of integers which I want
to combine together with &, "bitwise AND". Basically it's a simple
list of access levels that a user might have and I want to merge the
list into one value. There can be zero, one or more values in the list
so I have to be able to cope with the no-results .

For example
access
--------    31   511

Would lead to 31 & 511 which gives 31.

I guess really this can lead to the more generic question. How do I
apply a general function to combine the values, if I, for example,
wanted to write my own aggregate function like sum?

Thanks in advance,

Stephen Quinney






pgsql-sql by date:

Previous
From: drdani@mazsola.iit.uni-miskolc.hu
Date:
Subject: force command execution
Next
From: Sean Davis
Date:
Subject: Re: Combining values in a column