Is there anything in SQL2003 about such operators? If there is, we should make sure we use the correct aggregate names.
That's a point!
I thought of BIT_* because it is short and also used by mysql. Ingres has BIT_AND and BIT_OR functions, but they are not aggregates.
I don't know where these standards are available online... It seems they are not available:-(
Neil - can you check your SQL2003 copy to see if it mentions standard aggregates on bit types?
Thanks,
Chris
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend