| 00:20.54 | *** join/#udbug DexterTh1Dragon (n=admin@70-58-37-35.slkc.qwest.net) |
| 03:21.59 | *** join/#udbug DexterTheDragon (n=admin@oalug/member/blackchaos) |
| 03:21.59 | *** mode/#udbug [+o DexterTheDragon] by ChanServ |
| 13:57.43 | *** join/#udbug SunSparc (n=sparky@75.148.101.137) |
| 13:57.43 | *** mode/#udbug [+o SunSparc] by ChanServ |
| 14:54.35 | *** join/#udbug fungus (n=olsonl@bromine.sosstaffing.com) |
| 14:54.35 | *** mode/#udbug [+o fungus] by ChanServ |
| 15:23.29 | *** join/#udbug brasto (n=brasto@97-117-71-212.slkc.qwest.net) |
| 15:23.29 | *** mode/#udbug [+o brasto] by ChanServ |
| 16:10.09 | *** join/#udbug SunSparc_ (n=sparky@75.148.101.137) |
| 16:32.38 | *** join/#udbug SunSparc (n=sparky@75.148.101.137) |
| 16:32.38 | *** mode/#udbug [+o SunSparc] by ChanServ |
| 17:07.16 | *** join/#udbug SunSparc (n=sparky@75.148.101.137) |
| 17:07.41 | *** mode/#udbug [+o SunSparc] by ChanServ |
| 17:20.24 | eggyknap | unum: Sweet! A response to that email thread! W00T! :) |
| 17:20.42 | unum | sorry it's so late my main computer borked :) |
| 17:20.51 | eggyknap | heh. That's life. |
| 17:20.56 | unum | after 6 years I had to reinstall debian |
| 17:21.11 | unum | of course I had home on a different partition so it's fine |
| 17:21.37 | unum | that and I've been busy at work :) |
| 17:22.22 | eggyknap | knows how that goes sometimes. |
| 17:22.40 | unum | I should have said not the third tuesday |
| 17:22.49 | unum | that would be the worst day possible for me right now |
| 17:22.51 | eggyknap | I, eventually, have to bite the bullet and replace the home desktop. I'm not looking forward to it. |
| 17:23.00 | unum | any other day I could make it a priority |
| 17:23.06 | eggyknap | notes "tuesday #3" == "Bad" |
| 17:23.21 | unum | I want to buy a new computer but I bought a condo instead |
| 17:23.34 | eggyknap | heh |
| 17:23.43 | unum | back with house prices were out of hand and they were giving loans to people they shouldn't have |
| 17:24.02 | unum | I did get a new computer at work |
| 17:24.15 | unum | I should just take it home. I already have to two work computers |
| 17:24.36 | unum | it's kind of funny now sitting behind my three monitors |
| 17:25.47 | eggyknap | likes dual monitors... lots. |
| 17:26.00 | unum | I want to count the number of rows where a certain column is marked true and in the same query I want to count the number of columns where a differnt column is marked true |
| 17:26.15 | unum | and I want to return the results in the same row |
| 17:26.26 | unum | does anyone know how to do that in postgresql |
| 17:26.37 | unum | I have three computers+synergy it's really nice |
| 17:27.08 | *** join/#udbug beandog (n=steve@gentoo/developer/beandog) |
| 17:31.56 | eggyknap | unum: http://pastebin.com/m7a513353 |
| 17:33.03 | eggyknap | there may well be a faster way, like "count(case when b then 1 else null end)" instead of "sum(..." |
| 17:33.15 | eggyknap | I don't know which is faster, nor if it matters much :) |
| 17:33.19 | unum | eggyknap: thanks, I didn't think about doing the case statement inside of the count |
| 17:37.15 | unum | sweet. now on to the hard problem. |
| 17:37.39 | eggyknap | heh |
| 17:39.01 | unum | I should just do it the easy way rather than trying to be clever |
| 17:39.14 | unum | it's not like I'm running into speed issues |