code logs -> 2013 -> Thu, 24 Oct 2013< code.20131023.log - code.20131025.log >
--- Log opened Thu Oct 24 00:00:16 2013
00:03 himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code
00:03 mode/#code [+o himi] by ChanServ
00:05
<@gnolam>
Outlook's logo + Windows 8's taskbar/quicklaunch is a bad combo.
00:05
<@gnolam>
I keep reading it as "0 new messages" instead of a stylized O.
00:10 You're now known as TheWatcher[T-2]
00:14
<@Reiv>
Tarinaky: Are you assuming a setting where low energy missions will be a thing?
00:16
< RichyB>
Tarinaky, am I right in understanding here that what you're essentially trying to do is make a videogame about space flight that is better than Kerbal Space Program? :D
00:16 You're now known as TheWatcher[zZzZ]
00:16
< RichyB>
Tarinaky, in which case, fuck yeah, best of luck to you! The world needs more awesome videogames about fukkin' rockets. =D
00:19
<@Reiv>
RichyB: Nnot quite.
00:20
<@Reiv>
He's trying to rewrite Aurora, which is Dwarf Fortress: Galactic Empire Edition.
00:38 Harlow [Harlow@Nightstar-2dbe3d64.il.comcast.net] has joined #code
00:43
< RichyB>
Reiv, *reads up on Aurora*
00:44
< RichyB>
That is also COOL AS SHIT
00:44
< RichyB>
Tarinaky, godspeed! :D
00:44
<@Reiv>
RichyB: It's also an unplayable mess whose core engine is an Access database of terrifying vintage.
00:44
<@Reiv>
Tarinaky is having a crack at Doing It Properly.
00:47
<&McMartin>
Huh. There's still some progress being made in really simple PRNGs
00:47
<&McMartin>
http://b2d-f9r.blogspot.com/2010/08/16-bit-xorshift-rng-now-with-more.html
00:55 himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Operation timed out]
01:05 Turaiel[Offline] is now known as Turaiel
01:09 himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code
01:09 mode/#code [+o himi] by ChanServ
01:13 himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds]
01:25 himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code
01:25 mode/#code [+o himi] by ChanServ
01:38
<&ToxicFrog>
btsync >3
01:38
<&ToxicFrog>
<3 even
02:06 himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds]
02:07 Turaiel is now known as Turaiel[Offline]
03:21 VirusJTG [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has quit [[NS] Quit: Program Shutting down]
04:17 VirusJTG [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has joined #code
04:21 Kindamoody[zZz] is now known as Kindamoody
04:21 VirusJTG [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has quit [[NS] Quit: Program Shutting down]
04:49 LurtzCZ [Lurtz@Nightstar-0604e0ca.cust.termsnet.cz] has joined #code
04:51 himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code
04:51 mode/#code [+o himi] by ChanServ
05:03 Derakon is now known as Derakon[AFK]
05:10 ktemkin is now known as ktemkin[wol]
05:11 ktemkin[wol] is now known as ktemkin[away]
05:35 RichyB [RichyB@D553D1.68E9F7.02BB7C.3AF784] has quit [[NS] Quit: Gone.]
05:38 RichyB [RichyB@D553D1.68E9F7.02BB7C.3AF784] has joined #code
05:46 Turaiel[Offline] is now known as Turaiel
06:25 Vornicus [vorn@ServerAdministrator.Nightstar.Net] has joined #code
06:25 mode/#code [+qo Vornicus Vornicus] by ChanServ
06:26 ErikMesoy|sleep is now known as ErikMesoy
06:54 celticminstrel [celticminst@Nightstar-90d86201.dsl.bell.ca] has quit [[NS] Quit: And lo! The computer falls into a deep sleep, to awake again some other day!]
06:55 himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds]
07:00 Turaiel is now known as Turaiel[Offline]
07:09 himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code
07:09 mode/#code [+o himi] by ChanServ
07:10 LurtzCZ [Lurtz@Nightstar-0604e0ca.cust.termsnet.cz] has quit [Ping timeout: 121 seconds]
07:12 Harlow [Harlow@Nightstar-2dbe3d64.il.comcast.net] has quit [[NS] Quit: BED]
07:19 LurtzCZ [Lurtz@Nightstar-0604e0ca.cust.termsnet.cz] has joined #code
07:24
<~Vornicus>
The irony is thick like axe body spray in a high school boys' locker room: chrome lists php.net as having malware.
07:33
< Syka>
haha
07:46 himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds]
07:59 himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code
07:59 mode/#code [+o himi] by ChanServ
08:13 Vash [Vash@Nightstar-221158c7.sd.cox.net] has joined #code
08:13 mode/#code [+o Vash] by ChanServ
08:36 himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds]
08:48 himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code
08:48 mode/#code [+o himi] by ChanServ
09:01 You're now known as TheWatcher
09:20 Vash [Vash@Nightstar-221158c7.sd.cox.net] has quit [Ping timeout: 121 seconds]
09:37
< Attilla>
that's quite the simile
09:46 AverageJoe [evil1@Nightstar-9da8df73.ph.cox.net] has joined #code
10:12 thalass [thalass@Nightstar-141785b5.bigpond.net.au] has joined #code
10:49 himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds]
11:02 himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code
11:03 mode/#code [+o himi] by ChanServ
11:23 himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds]
11:37 himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code
11:37 mode/#code [+o himi] by ChanServ
11:44 himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds]
11:55 Kindamoody is now known as Kindamoody|out
11:57 himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code
11:57 mode/#code [+o himi] by ChanServ
12:06 AverageJoe [evil1@Nightstar-9da8df73.ph.cox.net] has quit [[NS] Quit: Leaving]
12:19 VirusJTG [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has joined #code
12:39 himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds]
12:48 Vash [Vash@Nightstar-221158c7.sd.cox.net] has joined #code
12:48 mode/#code [+o Vash] by ChanServ
12:51
<@Tarinaky>
Hmm... Imaging I have a massless particle controlled by an ai in an n-body simulation.
12:51
<@Tarinaky>
The AI wants to get from one body to another.
12:52 himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code
12:52 mode/#code [+o himi] by ChanServ
12:52
<@Tarinaky>
So it tries to find a solution using a conic trajectory, a-la KSP, and if it finds one verifies it's correct by running its own n-body simulation.
12:53
<@Tarinaky>
If it doesn't have enough deltaV to complete such a solution, what would be a good heuristic to guide a search.
12:54
<@Tarinaky>
Cartesian position would be an obvious one, but I am unsure whether it is a sensible one.
12:58
<@Tarinaky>
Need some way to reduce the search to some list of sensible maneuvers to try.
12:58
<@Tarinaky>
*search space
13:00 himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Operation timed out]
13:00 * TheWatcher eyes this, wtfs
13:01
<@TheWatcher>
git clone https://blablalbla/foo.git produces a directory I'd expect.
13:02
<@TheWatcher>
Using Git::Repository -> run(clone => $repository => $target, { ... opts ...}) produces a directory that contains files that were deleted
13:12 Vash [Vash@Nightstar-221158c7.sd.cox.net] has quit [[NS] Quit: I <3Lovecraft<3 Vorn!]
13:14 himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code
13:14 mode/#code [+o himi] by ChanServ
13:14
<@TheWatcher>
wait
13:14 * TheWatcher facepalms
13:17 celticminstrel [celticminst@Nightstar-90d86201.dsl.bell.ca] has joined #code
13:17 mode/#code [+o celticminstrel] by ChanServ
13:18 himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds]
13:31 himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code
13:31 mode/#code [+o himi] by ChanServ
13:41 himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds]
13:55 himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code
13:55 mode/#code [+o himi] by ChanServ
14:03
<@Azash>
http://www.gironsec.com/blog/2013/10/bypassing-fireeye-toorcon-vid-slides/
14:04
<@Tarinaky>
Argh. Can't seem to figure out how to use my universities e-journal system.
14:04
<@Tarinaky>
Tuition fees are the most useless fucking library card in my life.
14:09
<@froztbyte>
teehee
14:10
<@Azash>
For what it's worth, AverageJoe presented at Toorcon ^
14:10
<@TheWatcher>
Go ask the library staff; it's their job to know how to do what you need.
14:14
<@TheWatcher>
Also, writing documentation: good gods, how I hateses it.
14:59
< ErikMesoy>
Errors you don't want to see at an IT workplace: "Sys" is undefined in global.js
15:04 himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds]
15:08 Reiv [NSwebIRC@Nightstar-95746c1f.kinect.net.nz] has quit [Ping timeout: 121 seconds]
15:15 Vornicus [vorn@ServerAdministrator.Nightstar.Net] has quit [[NS] Quit: Leaving]
15:18 himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code
15:18 mode/#code [+o himi] by ChanServ
16:14
<&ToxicFrog>
TheWatcher: cloned the wrong thing?
16:14
<&ToxicFrog>
Tarinaky: er - if it's massless, conics don't apply, its trajectory is a straight* line
16:16
<@Tarinaky>
ToxicFrog: Negligible mass sorry.
16:16
<@Tarinaky>
ToxicFrog: I don't speak well when I'm thinking at the same time.
16:17
<@TheWatcher>
TF: no, even more dumb. The code that invoked Git::Repository was also doing a bunch of post-clone work, part of which involves modifying a given file if it exists or /creating it if it doesn't/...
16:17
<@TheWatcher>
Yeah >.>
16:20 Derakon[AFK] is now known as Derakon
16:26
<@Tarinaky>
I went to the library and asked. I've been told to email a different desk.
17:10
<@Tarinaky>
Lame. Apparently they don't have access to the journal for the year the article I want was published. :/
17:10
<@Tarinaky>
Boo. Hiss.
17:14
< Syka>
time to do an aaron swartz
17:17 himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds]
17:20 thalass is now known as Thalasleep
17:21 celticminstrel [celticminst@Nightstar-90d86201.dsl.bell.ca] has quit [[NS] Quit: And lo! The computer falls into a deep sleep, to awake again some other day!]
17:30 himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code
17:30 mode/#code [+o himi] by ChanServ
17:35 Turaiel[Offline] is now known as Turaiel
17:51 abudhabi [abudhabi@2B12AA.CA225B.06AE83.B2A635] has quit [Ping timeout: 121 seconds]
17:56 abudhabi [abudhabi@2B12AA.CA225B.06AE83.B2A635] has joined #code
18:02 abudhabi is now known as Wires
18:15
<@TheWatcher>
Tarinaky: what is it you're after? I might be able to get it for you
18:15 Kindamoody|out is now known as Kindamoody
18:15
<@Tarinaky>
TheWatcher: Trying to come up with a 'list' of maneuvers a space ship can perform, to use that as the elements from which to define a search space.
18:16
<@Tarinaky>
SPecifically, those relating to Libration points.
18:16
<@Tarinaky>
KSP has taught me enough to do simple transfers...
18:17
<@TheWatcher>
Okay, but which article are you after?
18:17
<@Tarinaky>
Oh, let me check.
18:18
<@Tarinaky>
'Targeting in Hamiltonian systems that have mixed regular/chaotic phase spaces'
18:18
<@TheWatcher>
pmid 12779678?
18:19
<@Tarinaky>
I have no idea what that means.
18:20
<@gnolam>
Wait, why would it have a PubMed ID?
18:21
<@gnolam>
Tarinaky: https://en.wikipedia.org/wiki/PMID#PubMed_identifier
18:22
<@gnolam>
I mean, a DOI, sure, but PMID? Weird.
18:24
<@Tarinaky>
I have no idea what the pmid is.
18:24
<@Tarinaky>
There isn't one listed in this database.
18:26 * TheWatcher eyes this
18:27
<@TheWatcher>
Well, I've found it, I think. http://scitation.aip.org/content/aip/journal/chaos/7/4/10.1063/1.166277 for example. However, even going through my uni's journal system, it won't let me at it for free
18:29
<@TheWatcher>
... yep, nothing, all end up going back to that page and no free options it seems.
18:30
<@Tarinaky>
Fair winds. It's not the end of the world.
18:40 Turaiel is now known as Turaiel[Offline]
18:59 himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds]
19:05
< ErikMesoy>
SQL: what's the syntax for counting how many subthings each of a type of thing has? I think I'm trying to write something that will give me "Science 3; Math 2" from a courses-and-study-groups table that contains the five entries (Science, group1), (Science, group2), (Science, group3), (Math, group1), (Math, group2).
19:05
< ErikMesoy>
Looking at something similar to "SELECT course, COUNT(group) FROM CourseGroupTable" but that's wrong. I have a longer table and it's only giving me the last entry.
19:06 Kindamoody is now known as Kindamoody|afk
19:13 himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code
19:13 mode/#code [+o himi] by ChanServ
19:13
< ErikMesoy>
SELECT course, COUNT(distinct group) FROM CourseGroupTable WHERE course="Science" gives me the "Science 3" result I want, but this only gives me one thing at a time. Saying WHERE course LIKE '%' doesn't give me a list either.
19:19 LurtzCZ [Lurtz@Nightstar-0604e0ca.cust.termsnet.cz] has quit [Ping timeout: 121 seconds]
19:22 Wires is now known as AnnoDomini
19:25
< RichyB>
SELECT course, COUNT(distinct group) FROM CourseGroupTable GROUP BY course; -- ?
19:25
< RichyB>
ErikMesoy, ?
19:27
< ErikMesoy>
Yes.
19:28
< ErikMesoy>
This works.
19:30
<@Tarinaky>
TheWatcher: Dumb question, any idea how to progress my research in light of this obstacle? I'm new to this whole independent learning thing >.>
19:30
< RichyB>
How old is the paper?
19:31
<@Tarinaky>
Published 1997
19:31
< RichyB>
Supposedly, if you can track down one of the authors, most academics will happily email a PDF, usually stamped with "DRAFT" or "PREPRINT", in response to a polite email.
19:32
< Syka>
they might even find it amusing if you mention it's for KSP manevours
19:32
< ErikMesoy>
Urgh. This next SQL exercise says I'm supposed to retrieve group information from the table of students; the group information isn't in the table of students, only the table of courses.
19:33
< ErikMesoy>
The exercise says "only the table Students shall be present in the FROM clause of the statement" which sounds like an exercise in accessing table Groups outside of the FROM clause. >_>
19:38 Kindamoody|afk is now known as Kindamoody
19:48
<@Tarinaky>
Syka: It's not for KSP. It's for something nelse.
19:49
<@Tarinaky>
KSP doesn't have any kind of provision for AI/Flight Computer unfortunately.
19:49
< Syka>
oh
19:49
< Syka>
Tarinaky: mechjeb?
19:49
<@Tarinaky>
Oh yeah But Mechjeb already does everything in KSP's model.
19:49
< Syka>
that's a flight computer, i think
19:49
< Syka>
oh
19:49
<@Tarinaky>
This is for something else either way.
19:50
<@Tarinaky>
Since KSP /only/ has conics.
19:50
< Syka>
...still, saying it's for KSP might help :D
19:50 * Syka awaits the day for a paper to have figures of KSP-based models
19:50
< Syka>
i guess ksp ignores the 3 body problem
19:51
<@Tarinaky>
I'm need to figure out an understanding of how libration-point transfers work so I can define a language encompassing them.
19:51
<@Tarinaky>
Well, need is too strong a word.
19:51
< Syka>
you may have been nerdsniped
19:51
<@Tarinaky>
Nerdsniped?
19:52
< Syka>
introduced to a problem where everything else shuts down until you've solved it
19:52
< Syka>
(or an 'interesting avenue of interllectual persuit')
19:52
<@Tarinaky>
Ah. Yes.
19:53
< Syka>
it's why i know lots of useless facts about things
19:55
<@Tarinaky>
Last time I got nerdsniped this badly was when I saw a problem about an infinite plane of resistors.
19:55
< Syka>
i think thats actually the example in the xkcd
19:56
< Syka>
since There Is Always A Relevant XKCD Comic
19:57
<@Tarinaky>
Quite likely.
19:57
< AnnoDomini>
Can't the infinite resistor plane be solved by extrapolating from increaningly large but finite resistor planes?
19:58
< Syka>
see, my solution for that is
19:58
< Syka>
'by observing the resistance, you change it'
19:58
< ErikMesoy>
Stop solving it. You don't have an infinite resistor plane.
19:58
<@Tarinaky>
iirc I built a geometric series that modelled the problem and was able to solve it using that.
19:58
< Syka>
i call it the 'quantum screw you'
19:58
<@Tarinaky>
19:57 < AnnoDomini> Can't the infinite resistor plane be solved by extrapolating from increaningly large but finite resistor planes?
19:58
<@Tarinaky>
Isn't that basically the definition of convergence?
19:59
< AnnoDomini>
ErikMesoy: Good idea.
20:00
< Syka>
what if you did have an infinite resistor plane
20:00
< Syka>
like, just sitting round
20:01
< AnnoDomini>
Then you could test it.
20:01
< AnnoDomini>
With a multimeter.
20:01
< Syka>
an even better question
20:01
< Syka>
how many radioshacks would you have to ransack to get that many 1 ohm resistors??
20:01
<@Tarinaky>
AnnoDomini: What's the resistance of the universe? :p
20:02
< AnnoDomini>
Tarinaky: Have a solution. http://www.mathpages.com/home/kmath668/kmath668.htm
20:02
<@Tarinaky>
Presumably there's enough ions floating around the interstellar medium that a sufficiently silly voltage could get a current :p
20:02
<@Tarinaky>
AnnoDomini: One nerd snipe at a time.
20:03
< AnnoDomini>
Measuring the impedance of the universe is beyond the ability of a multimeter. Therefore, it is not my problem.
20:03
< Syka>
pfft
20:03
< ErikMesoy>
:D
20:03
< Syka>
get some extension leads
20:03
< Syka>
she'll be right
20:03
< ErikMesoy>
Yeah, I like Anno's solution too.
20:05
< ErikMesoy>
I have a theoretical "this is never gonna happen" principled objection to very large things, and Anno has a more practical "outside my scope" objection to very large things. :p
20:05
< ErikMesoy>
Oh god here I go with the long statements of longness.
20:05
< ErikMesoy>
Write a SELECT statement to print out:
20:06
< Syka>
you want to see long statements of longness?
20:06
< Syka>
i was dealing with a database written by some medical systems
20:06
< Syka>
the INSERT statement in python took up 2.5 IRC buffers
20:07
< ErikMesoy>
ow.
20:07
< ErikMesoy>
my present exercise: "the course code, group number, and number of students for every group appearing in the CourseStudy table for the present semester (2013-2) using one line per group and course. Lines to be ordered alphabetically by course code and descending by group size. Do not include course INF1100."
20:07
< Syka>
it was um
20:07
< Syka>
let me find the statment
20:07
< Syka>
here is one section: " VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
20:09
< Syka>
it is dailywtf material, but i may leave it for a few years, just in case
20:09
< ErikMesoy>
heh
20:09
< Syka>
the guy i was working with
20:10
< Syka>
he means well, but holy shit is he a bad programmer :(
20:10
< Syka>
I just have to silently fix everything behind his back
20:10
< Syka>
but that project got cancelled (phew)
20:13
< ErikMesoy>
"WHERE code is not null AND code is not 'INF1100'" or "WHERE code is not null or 'INF1100'" or some other syntax, for a field that must be neither of two things?
20:13
< ErikMesoy>
"WHERE code not in (null, 'INF1100')" ? Is there a right way to do this?
20:14
<@Tarinaky>
I dunno whether I should try to find a good correspondence course in Maths if/when I can find a job to pay for it...
20:14
<@Tarinaky>
Does such a thing even exist? :/
20:20
<&Derakon>
Uh, there's billions of free online courses these days.
20:21
<&Derakon>
Just hit up Khan Academy or something.
20:21
<@Tarinaky>
Khan kindof stops at first year maths.
20:22 * ErikMesoy is very confused about how he's supposed to do something like "for each" in SQL. It seems to involve GROUP BY somehow.
20:23
<@Tarinaky>
Eugh. Great. Another article that's probably relevant to what I want to look up and it's in the same journal I can't access :/
20:23
<@Tarinaky>
-.-
20:28 Kindamoody is now known as Kindamoody[zZz]
20:37
<@Azash>
ErikMesoy: How do you mean for each?
20:38
<@Azash>
ErikMesoy: Also, make a Coursera account and look up Jennifer Widom's Introduction to Databases
20:38
<@Azash>
It's very good for getting you up to speed
20:39
< ErikMesoy>
Azash: For each course, I'm supposed to calculate the average number of students-per-group that course has.
20:40
<@Azash>
Mm, I can't remember it off-hand, admittedly
20:40
<@Azash>
My piece of advice still stands
20:41 * ErikMesoy does so. Aaagh, video lectures, unsearchable.
20:42
< AnnoDomini>
I think there's a function that calculates an average out of rows.
20:42
< AnnoDomini>
Also a keyword thingy that lets you break things down by a criterion.
20:43
< AnnoDomini>
Something like avg(something) group by field='smth'. It's been quite some time since I've used SQL.
20:43
< ErikMesoy>
AnnoDomini: My problem is that I don't have numeric rows. I have a set of student:course:group relationships, and I have a GROUP BY statement to print out "course X group 1 has N students. course X group 2 has M students".
20:44
<@Alek>
oh evil
20:44
<@Alek>
http://steike.com/code/useless/zip-file-quine/
20:44
< ErikMesoy>
I have to average M and N, and those don't exist in any table, so it seems I have to nest somehow.
20:44
< Syka>
you can do that using psuedotable things
20:44
< Syka>
i forget what theyre called
20:44
< Syka>
but you join in a fictional table (say, x)
20:44
< Syka>
and then query on x
20:45
< Syka>
but that may be a bit complicated for what theyre asking
20:45
< AnnoDomini>
Subselect?
20:47
<@Pandemic>
does any one know what the parseing conditions are for iOS and phone numbers
20:47
<@Pandemic>
specificly I'm trying to figure out formating limitations.
20:47
<@Pandemic>
does the parser support spaces for example?
20:52
< AnnoDomini>
ErikMesoy: Have you tried creating a table, feeding results of group membership calculations there, doing aggregation and grouping, and then deleting the table?
20:52
< ErikMesoy>
AnnoDomini: This is supposed to be done inside a select statement.
20:52
< AnnoDomini>
Have you tried a subselect?
20:52
< ErikMesoy>
I haven't figured out the right syntax for that.
20:53
<@Pandemic>
would an inner or outer join be useful in this situation?
20:53
< ErikMesoy>
All the examples I'm finding are for subselects in the WHERE clause.
20:53
< AnnoDomini>
http://en.wikipedia.org/wiki/Correlated_subquery
20:55
< ErikMesoy>
If you copypaste "SELECT distinct Country, COUNT(CustomerID) as 'people here' FROM Customers GROUP BY Country;" into the form at http://www.w3schools.com/sql/trysql.asp?filename=trysql_func_avg you will get an idea of what I'm working with.
20:56
< ErikMesoy>
Argentina 3, Austria 2 etc - now where do I put the brackets for saying AVG about this?
20:57
< AnnoDomini>
Rub it on everything.
20:57
< AnnoDomini>
Do what adventure games taught you!
20:57
< ErikMesoy>
Pfffft.
20:58
< AnnoDomini>
Likely suspects: AVG(COUNT(customerID)), AVG(people here).
20:59
< ErikMesoy>
Aha, worked it out with square brackets. SELECT AVG([people here]) FROM (SELECT distinct Country, COUNT(CustomerID) as 'people here' FROM Customers GROUP BY Country);
20:59
< AnnoDomini>
What do square brackets do?
21:00
< ErikMesoy>
Progress the adventure game. :V
21:04 * AnnoDomini checks. They just dekeywordize the contents.
21:08
< ErikMesoy>
That doesn't make me understand why I needed them here or why they work.
21:09
< AnnoDomini>
You needed them there because you used a space in the name of the virtual table you were making.
21:09
< AnnoDomini>
Normally 'people here' would be parsed as two separate words.
21:09
< AnnoDomini>
Since you meant this as one name, you needed [] to dekeywordize the space bar.
21:16 Vornicus [vorn@ServerAdministrator.Nightstar.Net] has joined #code
21:16 mode/#code [+qo Vornicus Vornicus] by ChanServ
21:20 celticminstrel [celticminst@Nightstar-90d86201.dsl.bell.ca] has joined #code
21:20 mode/#code [+o celticminstrel] by ChanServ
21:21 Harlow [Harlow@Nightstar-2dbe3d64.il.comcast.net] has joined #code
21:47 himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds]
21:52 Reiv [NSwebIRC@Nightstar-95746c1f.kinect.net.nz] has joined #code
21:52 mode/#code [+o Reiv] by ChanServ
22:00 himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code
22:00 mode/#code [+o himi] by ChanServ
22:02 Turaiel[Offline] is now known as Turaiel
22:18 NeoGeo64 [trizzo@Nightstar-a940610b.client.mchsi.com] has joined #code
22:20 himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds]
22:23 NeoGeo64 [trizzo@Nightstar-a940610b.client.mchsi.com] has left #code []
22:32 Turaiel is now known as Turaiel[Offline]
22:33 himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code
22:33 mode/#code [+o himi] by ChanServ
22:34 Harlow [Harlow@Nightstar-2dbe3d64.il.comcast.net] has quit [Ping timeout: 121 seconds]
22:34 Harlow [Harlow@Nightstar-2dbe3d64.il.comcast.net] has joined #code
22:39 himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds]
22:42 Harlow [Harlow@Nightstar-2dbe3d64.il.comcast.net] has quit [[NS] Quit: This computer has gone to sleep]
22:52 himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code
22:52 mode/#code [+o himi] by ChanServ
23:15 ErikMesoy is now known as ErikMesoy|sleep
23:16 himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds]
23:21 * McMartin finds the quote he was looking for yesterday.
23:21
<&McMartin>
"The existence and use of design patterns in a language are indicative of a weakness in the language itself, rather than a consequence of solving the problem at hand"
23:22
<&McMartin>
Also, heh. "It is a truth universally acknowledged that when you rant about the evils of a specific programming practice, you will find it mandatory within two days."
--- Log closed Fri Oct 25 00:00:31 2013
code logs -> 2013 -> Thu, 24 Oct 2013< code.20131023.log - code.20131025.log >

[ Latest log file ]