Re: current_timestamp after queries

On Mon, Sep 30, 2002 at 11:44:17AM +0200, Guido Staub wrote:

[some current_timestamp stuff] 

> I think that the accuracy is not good enough because I've started two
> BEGIN statements and some time is elapsing between them. Am I right?
> Or does anybody know a better solution to store the elapsed time after
> some queries without writing some code in C or JAVA?

Perhaps you're looking for timeofday()?

kleptog=# begin; select timeofday(); select timeofday(); commit;
BEGIN
              timeofday              
-------------------------------------
 Mon Sep 30 19:54:41.559605 2002 EST
(1 row)

              timeofday              
-------------------------------------
 Mon Sep 30 19:54:41.560018 2002 EST
(1 row)

COMMIT

Hope this helps,
-- 
Martijn van Oosterhout      http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.