To enable timing command to display correct result for over an hour SQL.
? psql
Index: common.c
===================================================================
RCS file: /projects/cvsroot/pgsql-server/src/bin/psql/common.c,v
retrieving revision 1.44
diff -u -r1.44 common.c
--- common.c 2002/09/04 20:31:35 1.44
+++ common.c 2002/09/14 04:16:47
@@ -464,7 +464,7 @@
/* Possible microtiming output */
if (pset.timing && success)
printf(gettext("Time: %.2f ms\n"),
- ((after.tv_sec - before.tv_sec) * 1000000 + after.tv_usec - before.tv_usec) / 1000.0);
+ ((after.tv_sec - before.tv_sec) * 1000000.0 + after.tv_usec - before.tv_usec) / 1000.0);
return success;
}