00:37.20 | *** mode/#udbug [+o DexterTheDragon] by ChanServ |
02:54.33 | *** join/#udbug DexterTh1Dragon (n=admin@63-226-100-66.slkc.qwest.net) |
03:48.51 | *** mode/#udbug [+o DexterTheDragon] by ChanServ |
14:46.23 | *** join/#udbug eggyknap (n=eggyknap@ip67-88-113-150.z113-88-67.customer.algx.net) |
14:46.23 | *** mode/#udbug [+o eggyknap] by ChanServ |
15:10.27 | *** join/#udbug fungus (n=olsonl@bromine.sosstaffing.com) |
15:10.27 | *** mode/#udbug [+o fungus] by ChanServ |
15:16.43 | *** join/#udbug eggyknap (n=eggyknap@ip67-88-113-150.z113-88-67.customer.algx.net) |
15:16.43 | *** mode/#udbug [+o eggyknap] by ChanServ |
15:35.26 | *** join/#udbug SunSparc (n=sparky@75.148.101.137) |
15:35.26 | *** mode/#udbug [+o SunSparc] by ChanServ |
17:18.21 | unum | what's the best way to get the first character from integer column in posgresql? |
17:31.45 | *** join/#udbug SunSparc (n=sparky@75.148.101.137) |
17:31.45 | *** mode/#udbug [+o SunSparc] by ChanServ |
17:43.30 | *** join/#udbug macnewbold (n=mac@166.70.178.114) |
17:43.30 | *** mode/#udbug [+o macnewbold] by ChanServ |
17:50.00 | eggyknap | unum: you're looking for the most significant digit, I guess, e.g. '1' in 137.6, 2 in 2.5, etc? |
18:54.54 | unum | ya |
18:55.17 | unum | right now I'm casting it to a character and it's getting me what I want |
18:56.14 | eggyknap | That may be the best way |
18:56.34 | eggyknap | Alternatively, divide each by 10 until the result is < 10, truncate it, and return that. |
18:56.48 | eggyknap | Could be faster, esp. if written as a C function. |
19:17.37 | unum | actually all the number's are in the 1000 range |
19:17.40 | unum | so that would be easy |
19:21.50 | eggyknap | Ah, well if you know that already, yeah, divide and trunc. |
21:08.28 | *** join/#udbug SunSparc_ (n=sparky@75.148.101.137) |
21:47.44 | *** join/#udbug SunSparc (n=sparky@75.148.101.137) |
21:47.44 | *** mode/#udbug [+o SunSparc] by ChanServ |
23:02.54 | *** join/#udbug Yorokobi (n=Yorokobi@unaffiliated/yorokobi) |
23:02.54 | *** mode/#udbug [+o Yorokobi] by ChanServ |