John D. Burger wrote: > In any event, you say you need to know when a row is less than 24 hours > old - that is presumably not an issue for these old rows. I would add > the column as suggested, but set it to some time in the past for the > existing rows. Or, you can set it to NULL, appropriately if you > interpret NULL as unknown, and test the age with something like this: > > where (age(coalesce(ts, '-infinity'::timestamp)) < '24 hours'::interval ...and actually you wouldn't even need the coalesce, as NULL < '24 hours'::interval IS NULL ...which is considered FALSE by the WHERE clause. It's probably wiser not to rely on that in your code though, it can be confusing ;) -- Alban Hertroys alban@xxxxxxxxxxxxxxxxx magproductions b.v. T: ++31(0)534346874 F: ++31(0)534346876 M: I: www.magproductions.nl A: Postbus 416 7500 AK Enschede // Integrate Your World //
