Hi all,
I'm trying the following:
BEGIN;select current_timestamp into mytable;.some queries.insert current timestamp into mytable;COMMIT;When I call this with the \i <filename> command, all is working fine, but the two current_timestamp entries are the same, there is no difference between them but there should. So I've tried:
BEGIN;select current_timestamp into mytable;.some queries.COMMIT;BEGIN;insert current_timestamp into mytable;COMMIT;and now the entries are different.
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?
Thanks in advance
Guido Staub