It is quite logical and when somebody does same in japanese section nobody complains.
2006-02-01 03217, 2006
Muz goes and makes some spaghetti
2006-02-01 03246, 2006
inhouseuk
I think the saying is something like - "education teaches you the way it should be done, employment shows you the way it is actually done"
2006-02-01 03253, 2006
ojnkpjg
one of my majors was computer science
2006-02-01 03203, 2006
ojnkpjg
i believe i learned very little about it in college
2006-02-01 03224, 2006
ojnkpjg
most people they graduate can't write simple programs
2006-02-01 03231, 2006
Muz
Education deludes you to set you up for a big fall when reality comes and bites you in the arse
2006-02-01 03237, 2006
Muz
I think that's somewhat more accurate
2006-02-01 03257, 2006
inhouseuk
Muz: that's true as well :)
2006-02-01 03201, 2006
ojnkpjg
i quit high school and did a lot of learning on my own before college
2006-02-01 03219, 2006
Muz
I missed out on the majority of my final year of high school
2006-02-01 03248, 2006
Muz
It shows too, I'm a complete retard when it comes to social skills with others my age and such, I'm out of touch and I know it :)
2006-02-01 03209, 2006
ojnkpjg
most college-aged people are slags, anyway
2006-02-01 03211, 2006
ojnkpjg
:P
2006-02-01 03216, 2006
Muz
That or their drugged up/drunken fuckwits who think it's funny to launch fireworks at 9pm in the middle fo a neighbourhood street
2006-02-01 03235, 2006
ojnkpjg
those are the sort i was thinking of
2006-02-01 03251, 2006
inhouseuk
I'm out of touch with that age group, I just don't understand their mentality
2006-02-01 03259, 2006
Muz
Nor do I at times
2006-02-01 03214, 2006
ojnkpjg
during the baseball playoffs a few years ago, all hell broke lose at my university
2006-02-01 03223, 2006
ojnkpjg
i was lucky enough to be a front-row spectator
2006-02-01 03227, 2006
ojnkpjg
people tipping cars over
2006-02-01 03231, 2006
ojnkpjg
and lighting dumpsters on fire
2006-02-01 03241, 2006
ojnkpjg
i have never seen anything like it
2006-02-01 03246, 2006
ojnkpjg
before or after
2006-02-01 03252, 2006
Muz
To think I used to partake in that crap too heh
2006-02-01 03203, 2006
ojnkpjg
the police were just standing there watching
2006-02-01 03233, 2006
ojnkpjg
people would use anything as an excuse to do things like that
2006-02-01 03243, 2006
ojnkpjg
it'd happen (to a lesser extent) every time there was a power outage
2006-02-01 03258, 2006
ojnkpjg
the power would go out, you'd count to 5, then you'd hear "WOOOOOOOOOOOOOOOOOOOO!"
2006-02-01 03206, 2006
ojnkpjg
and people would come rushing out of the dorm buildings
2006-02-01 03217, 2006
ojnkpjg
and they'd light whatever they could on fire
2006-02-01 03220, 2006
Muz
It's worse when it's "let's be retards... because it's Friday!!!!"
2006-02-01 03239, 2006
ojnkpjg
and thursday
2006-02-01 03241, 2006
ojnkpjg
and saturday
2006-02-01 03246, 2006
Muz
Hah yeah
2006-02-01 03246, 2006
ojnkpjg
and sunday
2006-02-01 03228, 2006
ojnkpjg
you can have some fun with drunk people, though
2006-02-01 03249, 2006
ojnkpjg
one night, this girl i didn't like much ambled in drunk as hell
2006-02-01 03257, 2006
inhouseuk
watching them fall over :)
2006-02-01 03202, 2006
ojnkpjg
and she started writing her name on those white dry-erase boards people had on their doors
2006-02-01 03207, 2006
ojnkpjg
her name was kate
2006-02-01 03213, 2006
ojnkpjg
i kept changing it to "katu"
2006-02-01 03217, 2006
ojnkpjg
then pointing it out to her
2006-02-01 03219, 2006
ojnkpjg
she was very confused
2006-02-01 03225, 2006
ojnkpjg
she'd go back and fix it, then i'd change it
2006-02-01 03230, 2006
ojnkpjg
tell ehr it was still "katu"
2006-02-01 03242, 2006
ojnkpjg
she went on like that for about 20 minutes
2006-02-01 03243, 2006
inhouseuk
that's cruel, but good fun :)
2006-02-01 03201, 2006
ojnkpjg
harmless fun
2006-02-01 03215, 2006
ojnkpjg
although she did always give me nasty looks after that
2006-02-01 03237, 2006
Muz
"omg leik u didnt tayk advantij of me coz i woz drunc"
2006-02-01 03241, 2006
nechto13
that's not cruel, leaving drunk people on their bosses lawn in the middle of the night is cruel
2006-02-01 03222, 2006
ojnkpjg
i always wanted to build a wall in front of somebody's door with cinder blocks
2006-02-01 03227, 2006
ojnkpjg
never got around to that
2006-02-01 03254, 2006
ojnkpjg
i can't even imagine how confused they'd be in the morning when they opened the door
2006-02-01 03217, 2006
ojnkpjg
the doors were easy to take off their hinges, too
2006-02-01 03221, 2006
ojnkpjg
so swapping them would have been easy
2006-02-01 03230, 2006
ojnkpjg
but i never ended up doing that, either
2006-02-01 03207, 2006
ojnkpjg
hell, just taking someone's door would be funny enough
2006-02-01 03222, 2006
inhouseuk
I once reversed all the door handles in the dorm, so you had to push them UP to open the door - that was fun to watch
2006-02-01 03231, 2006
ojnkpjg
hehe
2006-02-01 03221, 2006
ojnkpjg
a couple of years ago, this one drunken moron lived across from me
2006-02-01 03236, 2006
ojnkpjg
people would regularly come around and drop ads under dorm doors
2006-02-01 03245, 2006
ojnkpjg
so i put a recycling bin out in the hall
2006-02-01 03250, 2006
ojnkpjg
and taped a sign over it that said "ADS"
2006-02-01 03256, 2006
ojnkpjg
with an arrow down pointing to the barrel
2006-02-01 03216, 2006
ojnkpjg
one night, the guy across from me came back drunk and decided to dump a whole lot of beer into it
2006-02-01 03233, 2006
ojnkpjg
so i waited until he had his door open and emptied it into his doorway
2006-02-01 03246, 2006
Muz
Hahaha
2006-02-01 03254, 2006
ojnkpjg
he responded, "what are you doing? you didn't have to do that! now my floor has beer all over it!"
2006-02-01 03209, 2006
ojnkpjg
which was a really acute observation
2006-02-01 03233, 2006
wolfsong has quit
2006-02-01 03249, 2006
wolfsong joined the channel
2006-02-01 03229, 2006
Mudcrow has quit
2006-02-01 03223, 2006
Mudcrow joined the channel
2006-02-01 03243, 2006
MrQwerty` joined the channel
2006-02-01 03258, 2006
maloleche has quit
2006-02-01 03250, 2006
MrQwerty has quit
2006-02-01 03222, 2006
maloleche joined the channel
2006-02-01 03239, 2006
Scytale has quit
2006-02-01 03209, 2006
Scytale joined the channel
2006-02-01 03207, 2006
SenRepus has quit
2006-02-01 03207, 2006
joshk has quit
2006-02-01 03207, 2006
warp has quit
2006-02-01 03207, 2006
det has quit
2006-02-01 03200, 2006
warp joined the channel
2006-02-01 03227, 2006
joshk joined the channel
2006-02-01 03201, 2006
det joined the channel
2006-02-01 03226, 2006
yllona
g'night
2006-02-01 03236, 2006
nechto13
night yllona
2006-02-01 03237, 2006
yllona has quit
2006-02-01 03254, 2006
inhouseuk wonders if nikki_ is getting the today is birthday artists using a method similar to this
2006-02-01 03257, 2006
inhouseuk
select gid, name from (select gid, name, begindate, (extract(DOY from begindate::TIMESTAMP) = extract(DOY from TIMESTAMP 'NOW')) as is_birthday from artist where split_part(begindate,'-',2) != '00' and split_part(begindate,'-',3) != '00') AS t where is_birthday;
2006-02-01 03229, 2006
inhouseuk
it was fun because the date fields in the tables are char(10) and they can contain invalid true timestamp values
2006-02-01 03217, 2006
Muz
Fuck
2006-02-01 03220, 2006
Muz goes to bed
2006-02-01 03228, 2006
nechto13
good night muz
2006-02-01 03233, 2006
Muz
G'night
2006-02-01 03237, 2006
Muz is twitchy lol
2006-02-01 03240, 2006
inhouseuk
night Muz
2006-02-01 03250, 2006
Muz
Night in
2006-02-01 03252, 2006
Muz
house
2006-02-01 03217, 2006
ruaok
yep, inhouseuk... our partial dates can be a pain in the ass
2006-02-01 03229, 2006
ruaok
got a new trivia page to look at yet? :0)
2006-02-01 03237, 2006
inhouseuk
ruaok: give me a *little* while :)
2006-02-01 03258, 2006
nechto13
just to check that i've been doing the right thing all along. at least half of the artists that i added to ISO have russian sounding names, but i did not yield to temptation to put their names in cyrillic, since they could be from any one of the republics of former soviet union
2006-02-01 03202, 2006
inhouseuk
which might not be cyrillic such as in georgia :)
2006-02-01 03247, 2006
nechto13
right, that's why i didn't to do it. for some reason i put russian names for belarusian artists too, which sort of buffles me
2006-02-01 03251, 2006
inhouseuk
cool! it would have been Eva Cassidy's birthday tomorrow
2006-02-01 03230, 2006
nechto13
inhouseuk, do you eliminate groups out of result set or not?
2006-02-01 03219, 2006
inhouseuk
I'm not extracting all the columns out of the table anyway
2006-02-01 03249, 2006
inhouseuk
oh you mean group artists?
2006-02-01 03256, 2006
nechto13
right
2006-02-01 03240, 2006
inhouseuk
yes, I've now included an extra where clause 'type = 1' which only returns persons
2006-02-01 03212, 2006
inhouseuk
it wasn't in the code I pasted earlier
2006-02-01 03255, 2006
nechto13 noticed
2006-02-01 03236, 2006
nechto13
i see, what about type unknown artists? they could be aliases for people? :)
2006-02-01 03201, 2006
inhouseuk
yes, they are currently being excluded
2006-02-01 03212, 2006
nechto13
*performance names
2006-02-01 03215, 2006
nechto13
why?
2006-02-01 03248, 2006
nechto13
cause it's hard to tell if it's a person or not?
2006-02-01 03254, 2006
inhouseuk
yup
2006-02-01 03200, 2006
inhouseuk
for today there is 20 rows checking for type = 1 and 25 rows without
2006-02-01 03225, 2006
inhouseuk
but normally if there is a begindate set, the person/group will be as well
2006-02-01 03223, 2006
inhouseuk
4 of the 25 rows are groups
2006-02-01 03234, 2006
nechto13
i doubted that MB used different date fields for people's birthdays and group's founding dates
2006-02-01 03223, 2006
inhouseuk
correct, the same field is used
2006-02-01 03240, 2006
nechto13
i don't think i know any music fans who are so hardcore that they celebrate the founding dates of their favorite groups though
