On Mon, 30 Jun 2003 22:28:15 +1000
"Rudi Starcevic" <[EMAIL PROTECTED]> wrote:
> SELECT 1111 & 111 = 71
> I was expecting the second example to be
> SELECT 1111 & 111 = 111
hmm ..:
let's see:
dec(1111) is bin(10001010111)
dec(111) is bin(00001101111)
so, when we'll "AND" them:
1111 : 10001010111
111 : 00001101111
-------------------
00001000111 : dec: 71
quite reasonable, isn't it?
depesz
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
