things to do to avoid boredome

this weekend i removed the door from my bathroom. i have a small bathroom and it has a doorway right in the middle of one side of it. to get to the toilet one would have to open the door, walk inside, step towards the sink, close the door, then proceed. this sucked. especially when the needs were urgent. especially for quests who aren't as, shall we say, streamlined as i. so i pulled the door off the hinges. no more door, no more problem. now i just have to find a nice curtain for the portal. i think a bathroom curtain is more Bohemian than a bathroom door anyways.

and i'm all about the Bohemian, baby.

going through a database schema dump i found a funny little shnippet of code i wrote as a quick hack to locate orphaned financial statements during a particularly ugly data migration:

CREATE FUNCTION whereswaldo () RETURNS integer
AS '
DECLARE
company record;
oingo record;
bodycount int;
BEGIN
delete from milkcartons;
bodycount := 0;
for company in select distinct company_short_name from crude_statements
loop
select into oingo companyid from clientcompanies where whose = 1003 and position(company.company_short_name in companyid) > 0;
if not found
then
select into oingo max(delivery_period) as lastSeen from crude_statements where company_short_name = company.company_short_name;
insert into milkcartons values (company.company_short_name, oingo.lastSeen);
bodycount = bodycount + 1;
end if;
end loop;
return bodycount;
END;
'
LANGUAGE plpgsql;

evidently i was attempting to amuse myself during this rather boring task. i wonder if i succeeded.

on the way home from school yesterday, Peyton asked about where my mother lives. he's fascinated by issues of geography lately. i told him she lives on an island in the middle of the ocean where there is no winter called Oahu. i asked if he'd like me to show him where Oahu is on the map when we got home. he said yes, and then said "I know where the map is! You go to the games menu that looks like a controller, then you go to the smiley face, then you go to the bottom!" apparently he's memorized large portions of the kmenu. crazy.