determining the age of a row in postgresql?

[Dirk Moolman]

I do not know PostGreSQL, but from my knowledge of other databases
(Informix & Oracle), this functionality is normally not available.  On a
row level, you normally have to enable audits, or write triggers that
will update your own customised audit tables, to do something like this.



-----Original Message-----
From: linux-users-bounces at linux-sxs.org
[mailto:linux-users-bounces at linux-sxs.org] On Behalf Of Net Llama!
Sent: 07 June 2007 07:59 PM
To: linux-users at linux-sxs.org
Subject: determining the age of a row in postgresql?

I'm pulling my hair out trying to find a means of determining the age of
a 
row in a table in a PostgreSQL database.  I've googled, and found close
to 
nothing that doesn't require writing crazy triggers or altering the DB 
schema.  Surely this must be possible, right?

-- 
+AH4AfgB+AH4AfgB+AH4AfgB+AH4AfgB+AH4AfgB+AH4AfgB+AH4AfgB+AH4AfgB+AH4AfgB+AH4AfgB+AH4AfgB+AH4AfgB+AH4AfgB+AH4AfgB+AH4AfgB+AH4AfgB+AH4AfgB+AH4AfgB+AH4AfgB+AH4AfgB+AH4AfgB+AH4AfgB+AH4AfgB+AH4
Lonni J Friedman                        netllama at linux-sxs.org
LlamaLand				http://netllama.linux-sxs.org
_______________________________________________
Linux-users mailing list ( Linux-users at linux-sxs.org )
Unsub/Password/Etc:
http://mail.linux-sxs.org/cgi-bin/mailman/listinfo/linux-users

***  OFF TOPIC conversations should get sent to general at linux-sxs.org.
This rule will be strictly enforced.  ***

Need to chat further on this subject? Check out #linux-users on
irc.linux-sxs.org !


*** Disclaimer ***

The information contained in this e-mail is confidential and legally privileged and is intended solely for the addressee and to others who have the authority to receive it. Access to this e-mail by anyone else is unauthorized and as such, any disclosure, copying, distribution or any action taken or omitted in reliance on it is unlawful. If you have received this e-mail in error, please notify the sender immediately.

The views expressed in this e-mail are the views of the individual sender and should in no way be construed as the views of the Company.

The Company is not liable to ensure that outgoing e-mails are virus-free.

The Company is not liable, should information or data, for whatever reason, be corrupted or fail to reach its intended addressee.

The Company is not liable for any loss or damage of whatsoever nature and howsoever arising resulting from the opening or the use of the information in this e-mail, including its attachments and links.

The sender of this e-mail is subject to and bound by the terms and conditions of Company+IBk-s Electronic Communications Usage Policy.