current_timestamp after queries
От | Guido Staub |
---|---|
Тема | current_timestamp after queries |
Дата | |
Msg-id | 3D981CF1.BBFC907C@gik.uni-karlsruhe.de обсуждение исходный текст |
Ответы |
Re: current_timestamp after queries
Re: current_timestamp after queries |
Список | pgsql-general |
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?
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
В списке pgsql-general по дате отправления: