Re: age - Mailing list pgsql-general

From mixo
Subject Re: age
Date
Msg-id 3D341463.8090508@beth.uniforum.org.za
Whole thread Raw
In response to Re: age  ("Sam Liddicott" <sam.liddicott@ananova.com>)
List pgsql-general
That would solve the problem completely if I did not have a situation
where "status" (the other column) was not NULL - the reason for it
being that way is that it was added when the table was modified and
a  default value was not set. But, for now I am going to check if the
"locktime" is NULL before proceeding.

Sam Liddicott wrote:

>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
>
>
>
>




pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Question: merit / feasibility of compressing frontend
Next
From: Andrew Sullivan
Date:
Subject: Re: PostgreSQL in mission-critical system