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
delete from milkcartons;
bodycount := 0;
for company in select distinct company_short_name from crude_statements
select into oingo companyid from clientcompanies where whose = 1003 and position(company.company_short_name in companyid) > 0;
if not found
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;
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.