age

From: mixo <mixo(at)beth(dot)uniforum(dot)org(dot)za>
To: pgsql-general(at)postgresql(dot)org
Subject: age
Date: 2002-07-16 10:11:45
Message-ID: 3D33F161.8070408@beth.uniforum.org.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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"?

Browse pgsql-general by date

  From Date Subject
Next Message Sam Liddicott 2002-07-16 10:18:03 Re: age
Previous Message Curt Sampson 2002-07-16 09:10:04 Re: Pushing PostgreSQL to the Limit (urgent!)