If I have a table with an attribute of type "timestamp without time zone", what is the best way to query that table for records that are older than, say, one week.
I suppose I could get the current time in epoch seconds and the time of the attribute in the same, and select those records where the difference is greater than the number of seconds in a week. Is there something easier like SELECT * FROM table WHERE attribute IS OLDER THAN one week; Thanks. -- Brandon ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
