Re: [HACKERS] Timestamps

2004-02-09 Thread Christopher Kings-Lynne
I wanted to ask a simple question. Say I have a table with the timestamp field. What is the best way to say get all the records that were created say 2 hours before the query. One of the options would be to generate the timestamp in the correct format and then send a query in the format SELECT * f

Re: [HACKERS] Timestamps on schema objects

2003-11-07 Thread Christopher Kings-Lynne
People occasionally seem to ask for keeping time stamps on schema objects (tables, functions, etc.) about when they were created and last altered (in their structure, not the data in the tables). I think that this would be a relatively useful and painless feature. What do others think? It has act

Re: [HACKERS] Timestamps on schema objects

2003-11-07 Thread Dave Page
> -Original Message- > From: Peter Eisentraut [mailto:[EMAIL PROTECTED] > Sent: 07 November 2003 19:35 > To: PostgreSQL Development > Subject: [HACKERS] Timestamps on schema objects > > People occasionally seem to ask for keeping time stamps on > schema objects (tables, functions, etc