-- clear earlier stuff drop table if exists saints_in_our_book_20150801 cascade; -- create the current html page download into a table: create table saints_in_our_book_20150801 as select * from saints_in_our_book(); -- create a view out of that table (and add the 'away' colum): create or replace view saints_in_our_book as select *, replace(lasthere, ' ago', '')::interval as away from saints_in_our_book_20150801; -- query the view: $ echo " select * from saints_in_our_book -- the view on top of the table where away < '4 hours' order by now() - away desc , xp desc ; " | psql -qX rank | userid | username | xp | userlevel | writeups | usersince | lasthere | away ------+---------+----------------------+--------+-----------------+----------+---------------------+----------------+---------- 284 | 399498 | erix | 6400 | Vicar (15) | 362 | 2004-10-15 13:22:00 | 4 seconds ago | 00:00:04 6 | 461912 | GrandFather | 70930 | Sage (25) | 6450 | 2005-05-31 03:02:00 | 5 seconds ago | 00:00:05 108 | 70929 | atcroft | 15133 | Monsignor (18) | 633 | 2001-04-09 08:59:00 | 12 seconds ago | 00:00:12 80 | 401112 | johngg | 18402 | Abbot (19) | 1682 | 2004-10-21 10:23:00 | 17 seconds ago | 00:00:17 72 | 634253 | AnomalousMonk | 20401 | Abbot (19) | 2819 | 2007-08-22 06:27:00 | 52 seconds ago | 00:00:52 634 | 310300 | wjw | 3212 | Curate (13) | 371 | 2003-11-26 16:34:00 | 1 minute ago | 00:01:00 2 | 171588 | BrowserUk | 156800 | Pope (28) | 22020 | 2002-06-04 18:12:00 | 5 minutes ago | 00:05:00 49 | 832495 | choroba | 25807 | Canon (20) | 3418 | 2010-04-02 15:13:00 | 10 minutes ago | 00:10:00 37 | 176576 | eyepopslikeamosquito | 30092 | Chancellor (21) | 1295 | 2002-06-23 06:02:00 | 13 minutes ago | 00:13:00 287 | 1001958 | karlgoethebier | 6345 | Vicar (15) | 925 | 2012-11-02 12:43:00 | 20 minutes ago | 00:20:00 561 | 905403 | tangent | 3558 | Curate (13) | 363 | 2011-05-18 02:41:00 | 21 minutes ago | 00:21:00 254 | 491819 | ioannis | 6917 | Vicar (15) | 131 | 2005-09-14 11:10:00 | 27 minutes ago | 00:27:00 302 | 885521 | hippo | 6076 | Vicar (15) | 505 | 2011-02-01 15:37:00 | 27 minutes ago | 00:27:00 350 | 221725 | poj | 5228 | Priest (14) | 623 | 2002-12-22 10:42:00 | 27 minutes ago | 00:27:00 325 | 749850 | VinsWorldcom | 5667 | Vicar (15) | 326 | 2009-03-11 12:42:00 | 38 minutes ago | 00:38:00 267 | 436161 | davies | 6628 | Vicar (15) | 446 | 2005-03-03 11:39:00 | 42 minutes ago | 00:42:00 132 | 992570 | Laurent_R | 12485 | Monsignor (18) | 1850 | 2012-09-09 08:56:00 | 48 minutes ago | 00:48:00 110 | 200365 | Tux | 14738 | Monsignor (18) | 1440 | 2002-09-24 13:49:00 | 1 hour ago | 01:00:00 295 | 919638 | RichardK | 6195 | Vicar (15) | 396 | 2011-08-10 11:34:00 | 1 hour ago | 01:00:00 35 | 534893 | Gavin | 30799 | Chancellor (21) | 598 | 2006-03-07 12:15:00 | 2 hours ago | 02:00:00 71 | 968231 | Athanasius | 20547 | Abbot (19) | 1233 | 2012-05-01 11:13:00 | 2 hours ago | 02:00:00 147 | 747201 | afoken | 11033 | Prior (17) | 1139 | 2009-02-28 20:01:00 | 2 hours ago | 02:00:00 184 | 341121 | dave_the_m | 8997 | Parson (16) | 849 | 2004-03-30 22:38:00 | 2 hours ago | 02:00:00 331 | 1015412 | soonix | 5615 | Vicar (15) | 290 | 2013-01-25 21:42:00 | 2 hours ago | 02:00:00 367 | 222702 | parv | 5011 | Priest (14) | 690 | 2002-12-28 08:05:00 | 2 hours ago | 02:00:00 19 | 198160 | CountZero | 42943 | Bishop (22) | 4284 | 2002-09-16 05:38:00 | 3 hours ago | 03:00:00 39 | 524150 | syphilis | 29621 | Canon (20) | 2714 | 2006-01-19 07:30:00 | 3 hours ago | 03:00:00 41 | 708738 | LanX | 29231 | Canon (20) | 4599 | 2008-09-03 12:42:00 | 3 hours ago | 03:00:00 74 | 295576 | ambrus | 19603 | Abbot (19) | 2740 | 2003-10-01 11:47:00 | 3 hours ago | 03:00:00 88 | 446266 | salva | 17322 | Abbot (19) | 2243 | 2005-04-09 17:47:00 | 3 hours ago | 03:00:00 576 | 1039428 | Eily | 3498 | Curate (13) | 278 | 2013-06-17 17:59:00 | 3 hours ago | 03:00:00 (31 rows)