Skip site navigation (1) Skip section navigation (2)

Re: querying the age of a row

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: Lonni J Friedman <netllama(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: querying the age of a row
Date: 2007-06-07 18:49:30
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Lonni J Friedman wrote:
> 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.
> Someone on a different list suggested that I add a column that get
> now() each time a new row is inserted, but that unfortunately won't
> help me for all the pre-existing rows in this database.
> At any rate, is there a reliable way of querying a table for rows
> which have existed for a specific period of time?

So your table has no date or time stored in it at all?  If not, then you
cannot do the query that you are suggesting.


In response to


pgsql-novice by date

Next:From: Lonni J FriedmanDate: 2007-06-07 18:56:42
Subject: Re: querying the age of a row
Previous:From: Lonni J FriedmanDate: 2007-06-07 18:42:56
Subject: querying the age of a row

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group