Postgres Pro
Downloads
Home   >   mailing lists

Re: Negative result with (now()-previously_inserted_timestamp) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Negative result with (now()-previously_inserted_timestamp)
Date
Msg-id 25752.1278476281@sss.pgh.pa.us
Whole thread Raw
In response to Negative result with (now()-previously_inserted_timestamp)  (Gurjeet Singh <singh.gurjeet@gmail.com>)
Responses Re: Negative result with (now()-previously_inserted_timestamp)  (Gurjeet Singh <singh.gurjeet@gmail.com>)
Re: Negative result with (now()-previously_inserted_timestamp)  (Gurjeet Singh <singh.gurjeet@gmail.com>)
List pgsql-bugs
Tree view 
Gurjeet Singh <singh.gurjeet@gmail.com> writes:
> I ran the following query, and got an unexpected negative value. Does this
> imply that SELECT-transaction was able to see a row created by
> INSERT-transaction which started after the SELECT-transaction?

Was the SELECT inside a BEGIN block?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Gurjeet Singh
Date:
Subject: Negative result with (now()-previously_inserted_timestamp)
Next
From: Gurjeet Singh
Date:
Subject: Re: Negative result with (now()-previously_inserted_timestamp)