Re: [SQL] aggregate question

2003-06-24 Thread Hubert Lubaczewski
On Mon, 23 Jun 2003 13:59:52 -0500 (CDT) "Ryan" <[EMAIL PROTECTED]> wrote: > package_id | integer | not null default > I must be a total space case today because I can't hammer out the sql to > get a listing of all the packages with a count() of the package_log by > package_id. if you would

Re: [SQL] Bitwise operation

2003-06-30 Thread Hubert Lubaczewski
On Mon, 30 Jun 2003 22:28:15 +1000 "Rudi Starcevic" <[EMAIL PROTECTED]> wrote: > SELECT & 111 = 71 > I was expecting the second example to be > SELECT & 111 = 111 hmm ..: let's see: dec() is bin(10001010111) dec(111) is bin(110) so, when we'll "AND" them: : 10001010