I've got a table that I insert a value and a timestamp "now()". Then I
want to delete entries that are older than 30 minutes old. After some
experimentation, I found the following works, but it looks awkward and
backwards. Is there a better, more readable way of phrasing this or
rewriting it?
DELETE
FROM generators
WHERE age(now(),started) > interval '30 minutes'
--
Paul Tomblin <ptomblin@xcski.com>, not speaking for anybody
"Nobody can be told what the dominatrix is, they have to see it for themselves"
