- let sth = dbh#prepare_cached
- "select h.id, h.canonical_hostname,
- (select count(*) from pages
- where hostid = h.id and url is not null),
- (select max(last_modified_date) from pages
- where hostid = h.id and url is not null)
- from hosts h
- order by 2" in
- sth#execute [];
+ let rows = PGSQL(dbh)
+ "select h.id, h.canonical_hostname,
+ (select count(*) from pages
+ where hostid = h.id and url is not null),
+ (select max(last_modified_date) from pages
+ where hostid = h.id and url is not null)
+ from hosts h
+ order by 2" in