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: | 4668533A.5010003@mail.nih.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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.
Sean
From | Date | Subject | |
---|---|---|---|
Next Message | Lonni J Friedman | 2007-06-07 18:56:42 | Re: querying the age of a row |
Previous Message | Lonni J Friedman | 2007-06-07 18:42:56 | querying the age of a row |