[OSM-dev] Minute Diffs Broken

[Martijn van Oosterhout]

On Tue, May 5, 2009 at 2:30 AM, Steve Singer <ssinger_pg at sympatico.ca> wrote:
> What you want is the timestamp that the change was committed at, not the
> timestamp it was inserted at.  However there is no way to get this with
> postgresql.

I keep seeing this. See:

http://www.postgresql.org/docs/8.3/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT

You probably want clock_timestamp(). Doing this in a trigger (or
manually from the code) should work just fine.

Have a nice day,
-- 
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/