> -----Original Message-----
> From: mixo [mailto:mixo@beth.uniforum.org.za]
> Sent: 16 July 2002 11:12
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] age
>
>
>
> 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"?
Yeah, have another column for storing the age, or have another column to
store whether or not it is locked and don't use NULL in locktime.
You can't retreive data that you aren't storing.
Sam