On 10/16/2011 04:39 PM, Scott Marlowe wrote:
On Sun, Oct 16, 2011 at 5:24 PM, Tom Lane<t...@sss.pgh.pa.us> wrote:
Scott Marlowe<scott.marl...@gmail.com> writes:
On Sat, Oct 15, 2011 at 2:20 PM, Thomas Kellerer<spam_ea...@gmx.net> wrote:
Total runtime: -2.368 ms<<==== this is amazing ;)
I get something similar when I do select now()-query_start from
pg_stat_activity on my Ubuntu 10.04 / pg 8.3 servers.
Within a transaction block that's not surprising, because now() is
defined as transaction start time not statement start time.
No transaction block.
Even stand-alone statements take place within a transaction - just not
an explicit one.
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
