Interesting issue -- I have usually solved this by adding a specific field to each table with a default timestamp of NOW()...
When you: CREATE TABLE tbl ( blah... blah.... create_dt TIMESTAMP NOT NULL DEFAULT NOW() ); each and every record now has a timestamp of exactly when the row was created -- then it is a simple query to select, update, or delete WHERE create_dt < (NOW() - interval '1 day')... HTH.... ""Lonni J Friedman"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Greetings, > I've got a PostgreSQL-8.1.x database on a Linux box. I have a need to > determine which rows in a specific table are less than 24 hours old. > I've tried (and failed) to do this with the age() function. From what > I can tell, age() only has granularity down to days, and seems to > assume that anything matching today's date is less than 24 hours old, > even if there are rows from yesterday's date that existed less than 24 > hours ago. > > I've googled on this off and on for a few days, and have come up dry. > At any rate, is there a reliable way of querying a table for rows > which have existed for a specific period of time? > > -- > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > L. Friedman [EMAIL PROTECTED] > LlamaLand http://netllama.linux-sxs.org > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend