age - Mailing list pgsql-general

From mixo
Subject age
Date
Msg-id 3D33F161.8070408@beth.uniforum.org.za
Whole thread Raw
List pgsql-general
I lock rows based on 2 columns, "status" and "locktime". The idea is: if
the locktime has older than some age ( e.g. 1 minute), then the "status" bit
can be ignore, i.e. the lock expires. The problem I have is: if the
"locktime"
is "NULL" (this set when the lock is removed), then I can't get the age.
Is there a way to find the age of a column whose value can be or is  "NULL"?


pgsql-general by date:

Previous
From: stefan@extum.com
Date:
Subject: sequence id
Next
From: "Sam Liddicott"
Date:
Subject: Re: age